Issue with Sorting Months (By MonthNumber)

[#1]

Hi,

I am trying to sort the Month Name by Month Number as the Date formats / Week Formats are difficult to convert into QlikView Date formats using MakeDate.

Please help me in getting the chart to look like the one on the left but shows the Month Name.

The Forecast data should show up after the Actual Data.

Attaching the QVW File.

[deepakk · Accepted solution]

hi Chinmay,

Go to Sorting -- > Expression --> = MonthNumber -->Ascending

[#3]

Thanks Deepak.

I had tired this in my actual report which is still not working.

The demo file in which I have attached it working fine.

I will try to create the same scenario in a QVW file and share it with you.

-Thanks

Chinmay

[#4]

Hi Deepak,

I have tried to re create the issue in the demo file in which the Sorting on Month Number is not working.

The forecast table is a little different, which has two dates : the date in which the forecasting is done and the date for which the forecast is done.

So when I am selecting May in Selection, my forecast tables In Month = May (Fixed) the date range applies to the For Month.

Attaching the QVW File.

Regards,

Chinmay

[#5]

Hello,

Please find attachment. Sorting is done month wise.

[deepakk]

PFA

[#7]

Hi Ashwin,

The Load order would not work in my actual application where the data is not sorted.

Deepak suggested to use the below in the Expression sort which works great:

=min({<MonthName=>} MonthNumber)

[#8]

Deepak....

Thanks a lot....

U are superb in QlikView....

Everyday I am learning so many things from you.