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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to handle multiple "or" in calculated dimensions?

IF I want to do this:

IF(city='A' or city='B' or city='C' or ..., type=1,type=2)

Do I have to write the formula with multiple "or" function? Is there an easier way to do that?

1 Solution

Accepted Solutions
tresesco
MVP
MVP

You can use Match(). Like:

If(Match(City, 'A', 'B', 'C'), City)

View solution in original post

2 Replies
tresesco
MVP
MVP

You can use Match(). Like:

If(Match(City, 'A', 'B', 'C'), City)

Not applicable
Author

It really works. Thx