Sort order getting jumbled after selection in list box

Mon, 12 Oct 2015 17:22:26 GMT

My Fiscal months are Nov-Oct

I use the following to calculate the month number of my Fiscal

Calendar:

LOAD

D AS Link_Date,

D AS Date,

//Fiscal Dates

'Q' & Ceil(month(AddMonths(MonthsName(3,D,0,11),-10))/3) as FisQuarter,

num(month(AddMonths(MonthsName(1,D,0,11),-10)),'#0') as FisMo,

num(Year(AddMonths(MonthsName(1,D,0,11),+2)),'#0') as FisYr,

month(D) as FisMoShort,

When I create a list box that is a list of the fiscal month names (Nov, Dec, Jan .... etc), I set the sort order to Expression = FisMo and the months come out in the right order

When I make a month selection, the months get jumbled. Any ideas?

Re: Sort order getting jumbled after selection in list box

sunny_talwar — Mon, 12 Oct 2015 17:24:24 GMT

Try setting the sort order to this:

=Only({1} FisMo)

Re: Sort order getting jumbled after selection in list box

gaddeonline — Mon, 25 Jul 2016 00:45:45 GMT

HI Sunny,

This helped me.

Thanks and Regards

Mahesh Gadde

topic Re: Sort order getting jumbled after selection in list box in QlikView

Sort order getting jumbled after selection in list box

Re: Sort order getting jumbled after selection in list box

Re: Sort order getting jumbled after selection in list box