Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

New Contributor III

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.



1 Reply

Re: Max/Min Value in Pivot Table at 2 level

May be this

At year level

Sum(TOTAL <Year> Sales)

At year and month level

Sum(TOTAL <Year, Month> Sales)

Community Browser