Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Paknanarn23
Creator II
Creator II

I want to put multiple conditions in Dimensions

I want KCEPART to display data with the condition StdTxtKey_MS = MIC 1 , MIC2 , MIC.... and TCC1, TCC2 .... What should I do?

Paknanarn23_0-1701327277018.png

 

3 Replies
tabletuner
Creator III
Creator III

Calculated dimensions are bad for the performance of your app.

If the fields are in the same table then calculate a new field in the QlikView edit script modus with your if functions.

If the fields are not in the same table then try to join them first into the same table and then calculate the new field.

Use the new created field in the dimension of this object.

Paknanarn23
Creator II
Creator II
Author

What should I do? Do you have an example for me to look at?

tabletuner
Creator III
Creator III

Voila