Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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)