Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

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
Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted
Contributor
Contributor

Thanks Kaushik..