topic Re: Bad format of Month saved in variable in QlikView

Bad format of Month saved in variable

janturon — Wed, 24 Jan 2018 07:33:58 GMT

Hi,

I need help with variable.

I have Field Month with values in format like this:

Month

I have defined variable:

vmaxmonth=Max(Month)

But result of vmaxmonth in set analysis or text object is not 03, but 3.

kaushiknsolanki — Wed, 24 Jan 2018 07:38:21 GMT

Hi,

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')

Regards,

Kaushik Solanki

janturon — Wed, 24 Jan 2018 07:50:33 GMT

This is right: num(Max(Month),'00')

Where can I see format of Fields?

kaushiknsolanki — Wed, 24 Jan 2018 07:55:51 GMT

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.

Regards,

Kaushik Solanki