Discussion Board for collaboration related to Creating Analytics for QlikView.
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:
2. Calculated dimension: if Distributor have more than one distinct Type business - Type business, else - set value 'Less than 1 type'
You can use the below function in your calculated dimension:
Hope this helps.