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: 
sarasmonu
Creator
Creator

Max/Min Value in Pivot Table at 2 level

Hi All,

I am looking to  get information of max and min sales respectively at Year level and Month level.

Example: Get the max/min sales value among all month of the Year and display that at Year level.

Likewise, display max/mix value among all days of the month and display that at Month level.

Thanks,

Monu

1 Reply
sunny_talwar

May be this

At year level

Sum(TOTAL <Year> Sales)


At year and month level

Sum(TOTAL <Year, Month> Sales)