Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
shrutipg
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
TiagoCardoso
Creator II
Creator II

Hi, sorry for my english,

Maybe this help you

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