Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kalpesh13
Contributor
Contributor

aggr within if statement

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.

Qlik_Query.JPG

1 Solution

Accepted Solutions
kaushiknsolanki

Try this.

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

2 Replies
kaushiknsolanki

Try this.

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

kalpesh13
Contributor
Contributor
Author

Thanks Kaushik..