Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
DestinedTale
Contributor II
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]),samplecom.PNG

1 Solution

Accepted Solutions
jonathandienst

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

View solution in original post

3 Replies
vishsaggi
Champion III
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?
pradosh_thakur
Master II
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.
jonathandienst

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

View solution in original post