topic How to Calculate aggr for performance in expression in QlikView

How to Calculate aggr for performance in expression

Fia_Fiia — Wed, 25 Nov 2020 16:16:04 GMT

Hi, please help me

I want show this condition (see attachment) when all filters are removed this formula is not work, but if Filter I choose Month this formula is work. What should I do?

This my formula for High Perfomance:

sum(aggr(
if( SUM(AGGR(if([Status Performance]='Good',1,0),Aspek,Bulan,Name)) >6 ,1)
,Name, Bulan, Tahun))

This my formula for Medium Perfomance:

sum(aggr(
if(SUM(AGGR(if([Status Performance]='Good',1,0),Aspek, Bulan, Name))>=4 and SUM(AGGR(if([Status Performance]='Good',1,0),Aspek, Bulan, Name)) <=6,1)
,Name, Bulan, Tahun))

This is formula for Low Performance:

sum(aggr(if(SUM(AGGR(if([Status Performance]='Good',1,0),Aspek, Bulan, Name))<4,1),FTO, Bulan, Tahun))

Re: How to Calculate aggr for performance in expression

Arthur_Fong — Mon, 11 Nov 2019 02:43:03 GMT

How do you get performance High =1, when there is 6 Medium Performance?

If I understand your logic correctly, Medium Performance have to be greater than 6 in order for the expression to reflect as High.

Did I missed out something here?

Re: How to Calculate aggr for performance in expression

Brett_Bleess — Wed, 13 Nov 2019 16:47:35 GMT

Fia, the best I have in addition to what Arthur posted is the following:

https://community.qlik.com/t5/Qlik-Design-Blog/Use-Aggregation-Functions/ba-p/1475833

There are quite a few posts on AGGR in the Design Blog area, so if the above and the other links included in that post do not completely help, try the base URL for the area and search yourself to see if you can find something more specific...

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett