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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewaf
Creator
Creator

Find MAX Value - Pivot Table

Hi,

i have a pivot table structured as below (several rows by customer).

I would like to set an expression in QV as in coluimn F. I would like to have the max value of Days repeated for each line by customer. 

E.g. for customer 1, max value in column E (days), is 106, that's why in column F it's repeated for each row (same customer).

How i can achieve this?
Thank you so much!!

 

QLIK MAX.PNG

Labels (1)
1 Reply
edwin
Master II
Master II

try

=max(total <CUSTOMER> DAYS)