Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

vijetasharma
Valued Contributor

Calculating expression based on variable

Hi All,

We have all the calculation adhoc in straight table even for flag which based on the difference between two values.

now, I want to calculate count of accounts based on that flag. 

Any idea how can we achieve this.

for Flag, we have calculated expression like, if($(vDifference) <0,'Bad',if((vDifference) >0,'Good','No Change'))

Regards,

Vijeta

 

2 Replies
bharathadde
Contributor II

Re: Calculating expression based on variable

For count of accounts with Bad

=Count({<flag ={'Bad'}>}Accounts)

For count of accounts with Good

=Count({<flag ={'Good'}>}Accounts)

For count of accounts with No Change

=Count({<flag ={'No Change'}>}Accounts)

Highlighted
vijetasharma
Valued Contributor

Re: Calculating expression based on variable

this flag is calculated on the fly in variable  which has expression, if($(vDifference) <0,'Bad',if((vDifference) >0,'Good','No Change')).

 

I don't have direct flag field

Thanks!