Discussion board where members can get started with QlikView.
Hy guys ,
I have values for each month :Jan-1
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.
SUBFIELD(month ,'-',2) as num
then can take max(num)
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...
Can u make a variable
and expression like
if(value=vmax,value) and month as dimension.