Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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