topic Re: aggr within if statement in QlikView

aggr within if statement

kalpesh13 — Wed, 21 Oct 2020 00:04:27 GMT

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 — Wed, 21 Oct 2020 05:22:56 GMT

Try this.

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

kalpesh13 — Thu, 22 Oct 2020 02:58:09 GMT

Thanks Kaushik..