topic Re: Custom Month Order in QlikView

Custom Month Order

reshmakala — Thu, 14 Jul 2016 14:27:30 GMT

Hello All,

I have seen lot of posts regarding getting the custom month sort order and I have followed those steps. I still have a problem in the sort order. The expression am using in sort is

match(FY_Month,'Oct','Nov','Dec','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep')

Only the month order in the sheet activated while document open is having the right order. I tried changing it to sheet2 and open. In that case Month order works in sheet2. If I open with Sheet1 as opening page, month order is correct in sheet1 and wrong in sheet2.

Attached is the sample qvw. Please help.

Re: Custom Month Order

sunny_talwar — Thu, 14 Jul 2016 14:37:21 GMT

Try this:

Match(Only({1}FY_Month),'Oct','Nov','Dec','Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep')

Re: Custom Month Order

reshmakala — Thu, 14 Jul 2016 14:40:04 GMT

Thank you so much. Could you explain how using Only would help in this?

Re: Custom Month Order

sunny_talwar — Thu, 14 Jul 2016 14:41:45 GMT

It seems that there were some selections which were causing the field FY_Month to become null. I just forced FY_Month to not change based on any selections using {1}. But in order to use {1}, I need some aggregation and I used Only().

Re: Custom Month Order

reshmakala — Thu, 14 Jul 2016 14:42:55 GMT

Thank you!