Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Maguelonne
Contributor
Contributor

Fix KPI in a aggr function

Hello all, 

I would like to fix a KPI whatever the filters selected. 

To count the number of unique X it works: Count(Distinct{1}(X)) but I am not able to fix the expression below:

sum(aggr({1}WE_Total_Cost_Max, PN1,PN2))

Thanks 

Labels (3)
2 Replies
Or
MVP
MVP

Why are you summing aggr()? Why not just sum the value?

Maguelonne
Contributor
Contributor
Author

because I can have duplica such as:

total cost=5, PN1=a, PN2=b, c=x1

total cost=5, PN1=a, PN2=b, c=x2 

and I would like to have the total cost=5  and not 10. it is why I take the sum aggregated on PN1 and PN2