Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
pashok75
Contributor II
Contributor II

how to use conditional dimension to filter data

Dear all,

I have 4 cities A,B,C,D in the dimension.

 

CITYPRODUCTION
A1000
B2000
C1000
D2000

I need to filter on A,B through calculated dimension. How can use the following functions.

1. =

2. <>

3. Like

4. Not Like

Ashok

12 Replies
pashok75
Contributor II
Contributor II
Author

NOT inputing the expression in the statement.

pashok75
Contributor II
Contributor II
Author

Dear Shoham,

Once I made it calculated dimension the data filters. Thank you so much.

Or
MVP
MVP

Glad to help.

What I would recommend in this case is to create a filtered dimension in your script (with the same syntax) and then use it as a chart dimension. It's "healthier" than using a calculated dimension in charts and should also be quicker / less resource intensive.