Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
razvan_brais
Creator III
Creator III

Max of month year value

Hy guys ,

Please help.

I have values for each month :
Jan-1

Feb-3

Mar-2

Apr-4

May-7

Jun-6

Jul-9

Aug-12

Sep-33

Oct-1

Nov-4

Dec-2

I need to take the maximum value from those month : 33 in this case . I need this to be done in an expression. Could you please help.

Thanks,

Razvan

4 Replies
shreya_nadkarni
Partner - Creator
Partner - Creator

Try this:

SUBFIELD(month ,'-',2) as num

then can take max(num)

shreya_nadkarni
Partner - Creator
Partner - Creator

max(SUBFIELD(num,'-',2))

razvan_brais
Creator III
Creator III
Author

The data is not as a string. It is in a table , in different columns. One column for month , and another for values.

An I need to calculate the max without selecting any month...

shreya_nadkarni
Partner - Creator
Partner - Creator

Can u make a variable

vmax =max(value)

and expression like

if(value=vmax,value) and month as dimension.