topic Issue with Sorting Months (By MonthNumber) in QlikView

Issue with Sorting Months (By MonthNumber)

Fri, 04 Mar 2011 06:23:50 GMT

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.

Issue with Sorting Months (By MonthNumber)

deepakk — Fri, 04 Mar 2011 06:31:13 GMT

hi Chinmay,

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

Issue with Sorting Months (By MonthNumber)

Fri, 04 Mar 2011 06:46:43 GMT

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

Issue with Sorting Months (By MonthNumber)

Fri, 04 Mar 2011 08:08:39 GMT

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

Issue with Sorting Months (By MonthNumber)

Fri, 04 Mar 2011 08:15:54 GMT

Hello,

Please find attachment. Sorting is done month wise.

Issue with Sorting Months (By MonthNumber)

deepakk — Fri, 04 Mar 2011 08:20:52 GMT

PFA

Issue with Sorting Months (By MonthNumber)

Fri, 04 Mar 2011 08:32:26 GMT

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)

Issue with Sorting Months (By MonthNumber)

Fri, 04 Mar 2011 08:33:40 GMT

Deepak....

Thanks a lot....

U are superb in QlikView....

Everyday I am learning so many things from you.