Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

KPI Calculation : having variable with nested aggregation

I have a measure Update Score ( Values  : 1, 2,3 )

Update score is calculated by range comparison in if then else i.e

update score = [ if avg( min a + min b ) between 2 and 5 then 1 else so on ]

In KPI caluculation : 

=count({<'$V_Update_score'={'3'}>}([Test ID]))    to count test_ids where update_score = 3 

This expression is not taking where clause in set analysis and returning just the total ids.

Please suggest.


Labels (3)
1 Reply
Creator II
Creator II

Hi, sorry for my english,

Maybe this help you

=count({<[Test ID]={"=$(V_Update_score)=3"}>} [Test ID] )