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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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