Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
vijetas42
Specialist
Specialist

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
Creator II
Creator II

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
Specialist
Specialist
Author

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!