QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for
Did you mean:
Contributor II

Display max value for the month

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]),

1 Solution

Accepted Solutions

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
3 Replies
Champion III
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?
Master II
Where do you want to show the max value ? And again why using sum if you want the max value?
Learning never stops.

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein