Find MAX Value - Pivot Table

qlikviewaf — Thu, 04 Feb 2021 13:28:34 GMT

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!!

Re: Find MAX Value - Pivot Table

edwin — Thu, 04 Feb 2021 13:41:10 GMT

try

=max(total <CUSTOMER> DAYS)