topic Display max value for the month in QlikView

Display max value for the month

DestinedTale — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a graph where i want to display the max value for Jan and Dec.

Current value:

Value for jan is 22

Value for Dec is 18

Expected result:

Value for jan is 19

Value for Dec is 16

Expression is

Sum({$<Context=,FactType={"Customer"},[Month Year]={"$(vPre11Month)"}, Month=,Year= >}[Aging Days]),

Re: Display max value for the month

vishsaggi — Fri, 01 Feb 2019 03:57:57 GMT

Not quite sure about your expression, can you share some sample data and where you want to see your expected output like in a straight table?

Re: Display max value for the month

pradosh_thakur — Fri, 01 Feb 2019 04:09:04 GMT

Where do you want to show the max value ? And again why using sum if you want the max value?

Re: Display max value for the month

jonathandienst — Fri, 01 Feb 2019 05:26:04 GMT

Create a Month field (if you have not already done so) and add create a straight table (not table box) with month and the ID value as dimensions and Max() for the expression rather than Sum(). Change the total to 'Sum of Rows' in the expressions tab.