Discussion Board for collaboration related to QlikView App Development.
I need help with variable.
I have Field Month with values in format like this:
I have defined variable:
But result of vmaxmonth in set analysis or text object is not 03, but 3.
This depends on what data format you have in Month field.
If it is a Text then you should use the Maxstring instead of Max function.
If it is a numeric value you should use num(Max(Month),'00')
View solution in original post
This is right: num(Max(Month),'00')
Where can I see format of Fields?
The Easy option is, add the filter on sheet and observe the data, if it is on left side it is text else it is number.