Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
seahyanzheng
Contributor III
Contributor III

max sum

I have a dimension Step and expression - Unique Customer (sum([Customer Count])). i want to create max of Unique Customer but unable to do so with max(sum([Customer Count])). How do i get the results as shown below?


Customer CNT.PNG

16 Replies
seahyanzheng
Contributor III
Contributor III
Author

Sure.

This is how it looks like after removing suppression:

Customer CNT.PNG

Many thanks for all help.

pradosh_thakur
Master II
Master II

Exactly what i was suspecting. If you scroll down you can see a null value in dimension and it has the max value which is getting shown . so to ignore the null and to have 612091 as max in all rows use if(len(trim(Step_Nnull))>0,Step_Nnull) as dimension.

regards

Pradosh

Learning never stops.
pradosh_thakur
Master II
Master II

or with suppress null

Max(TOTAL Aggr(Sum({< Step_Nnull ={"*"}>}[Customer Count]), Step_Nnull))


as expression

Learning never stops.
seahyanzheng
Contributor III
Contributor III
Author

Thanks i get it now!Capture.PNG

But for some reason the calculated dimension is not working though.

pradosh_thakur
Master II
Master II

try the above expression with Step_Nnull as dimension and suppress null.

Learning never stops.
seahyanzheng
Contributor III
Contributor III
Author

Wow. Saw your second reply and it works! Thank you very much.

Capture.PNG

seahyanzheng
Contributor III
Contributor III
Author

Many thanks to Pradosh and Sunny!