topic SORTING-Load Order in QlikView

SORTING-Load Order

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need the load order of the months to be sorted in the script. For year 2017, the months seem to be sorted but for 2018 it starts from Month 6(using fiscal calendar starting from OCT-Month1).

I need to sort it in the script itself and not as a chart property. Thanks!

X-Axis: 'FY' & right(num#(FiscalYear),2) & ' ' & 'M' & num#(FiscalMonth) as testdate

Re: SORTING-Load Order

CarlosAMonroy — Wed, 04 Apr 2018 22:15:31 GMT

Hi Chandni,

It's better and easy to sort if you create the 'MonthYear' field in the backend (script.)

I guess you have Fiscal Date, so you can create the new field based on that.

Would be great if you share a sample file.

Regards,

Carlos M

Re: SORTING-Load Order

sunny_talwar — Wed, 04 Apr 2018 22:17:14 GMT

What is the script that you are using?

Re: SORTING-Load Order

jolivares — Wed, 04 Apr 2018 23:09:54 GMT

I feel that you need to redo your calendar table (I hope that you are using one)

Load Dual(MyMonth,MyFiscalMonth) as MyFiscalMonth2

MonthName(MakeDate(FYear,MyFiscalMonth) as MonYear;

Load Normarl_Date,

Month(Normal_Date) as MyMonth

Mod(Num(Month(Normal_Date))-10,12)+1 as MyFiscalMonth //10 is the first fiscal month for you

Year(Normal_Date) + If(Month(Normal_Date)>=10,1,0) as FYear

...