Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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] )