Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Check condition in calculated dimension

Good day!

I have test model to try check some thing:

I have three fields: Distributor, Type business, Volume

I need to create pivot table with such dimensions:

1. Distributor

2. Calculated dimension: if Distributor have more than one distinct Type business - Type business, else - set value 'Less than 1 type'

Expression:

sum(volume)

Thanks.

1 Reply
sinanozdemir
Specialist III
Specialist III

You can use the below function in your calculated dimension:

Capture.PNG

Hope this helps.

Thanks