Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
razvan_brais
Contributor II

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
Partner
Partner

Re: Max of month year value

Try this:

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

then can take max(num)

Partner
Partner

Re: Max of month year value

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

razvan_brais
Contributor II

Re: Max of month year value

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...

Partner
Partner

Re: Max of month year value

Can u make a variable

vmax =max(value)

and expression like

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