Solved: Re: aggr within if statement - Qlik Community

kalpesh13 · ‎2020-10-20

Hi,

I cant figure out query to get single amount (highlighted) as KPI figure.

I am looking for a correct query for

KPI chart formula :

SUM( IF( Aggr ( COUNT (distinct C_NonCat_Flag) ,W3_Desc) > 1 AND C_NonCat_Flag = 'NC',Amount,0 ))

Thank you.

kaushiknsolanki · ‎2020-10-21

Try this.

Sum({<W3_Desc = {'=Aggr(Count(Distinct C_NonCat_Flag),W3_Desc)>1'},C_NonCat_Flag = {"NC"}>}Amount)

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

kaushiknsolanki · ‎2020-10-21

Try this.

Sum({<W3_Desc = {'=Aggr(Count(Distinct C_NonCat_Flag),W3_Desc)>1'},C_NonCat_Flag = {"NC"}>}Amount)

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

kalpesh13 · ‎2020-10-21

Thanks Kaushik..