topic Re: Calculating expression based on variable in QlikView

Calculating expression based on variable

vijetas42 — Thu, 22 Aug 2019 13:31:36 GMT

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

bharathadde — Thu, 22 Aug 2019 19:20:44 GMT

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)

vijetas42 — Fri, 23 Aug 2019 10:03:20 GMT

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!