Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Help with MaxString!

Hi All

In one of our application. Month is considered as A1,A2..A12. To get the max of month in this format I have been using MaxString(MONTH). Looks like it is not working as expected as the max(MONTH) should be A10 but it is still displaying A9 as the max of month.

Please let me know what function will give the result that I need.

Thanks

Attitude

Tags (1)
4 Replies
SunilChauhan
Esteemed Contributor

Re: Help with MaxString!

see the attached file

hope this helps

Not applicable

Help with MaxString!

Hi Sunil

Can you please do everything in the script level instead of using variable.

Thanks

Attitude

Not applicable

Help with MaxString!

Hi All

If month contains A1,A2,A3,A4,A5,A6,A7,A8,A9 and A10. Function should return A10 as the max(month).

Thanks

Attitude

SunilChauhan
Esteemed Contributor

Re: Help with MaxString!

see the attached file

hope it make you haapy