Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

andreyfcdk91
New Contributor III

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
Valued Contributor III

Re: Check condition in calculated dimension

You can use the below function in your calculated dimension:

Capture.PNG

Hope this helps.

Thanks

Community Browser