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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register 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

1 Reply
edwin
Master II
Master II

try

=max(total <CUSTOMER> DAYS)