topic Re: Sort Months in QlikView

Sort Months

Thu, 12 Sep 2013 08:54:13 GMT

Hi,

i have 2 fields for months and 2 for years

month1,month2,year1,year2

suppose the user select july from month1 and year1=2013

and select february from month2 and year2=2014

in the chart i'm displaying the sales within this period

i.e the month is the dimension and i have 2 expressions:

1- sum(sales) for the selected period

2-sum(sales) for previous year period (from july 2012 to february 2013)

what i want is to sort the dimension of the month in the chart to be july-august-september-oct-nov-dec-jan-feb

because the chart sort them as jan-feb-july-august-....

So,,How can i sort the dimension?

Thanks in Advance.

Re: Sort Months

Sokkorn — Thu, 12 Sep 2013 09:45:08 GMT

Hi Mona,

Let try to sort dimension by expression. Right click on chart -> Properties -> Sort -> Check on Expression then using

(YearField*100)+Num(MonthField)

Regards,

Sokkorn

Re: Sort Months

Thu, 12 Sep 2013 10:02:39 GMT

Hi Sokkorn,

no not working !

Re: Sort Months

Sokkorn — Thu, 12 Sep 2013 10:03:52 GMT

Hi Mona,

Can you share your app?

Regards,

Sokkorn

Re: Sort Months

abeyphilip — Thu, 12 Sep 2013 10:04:34 GMT

Hi,

You can also try this in your sort expression and then sort Ascending:

if (month_fld='Jul',1,

if (month_fld='Aug',2,

if (month_fld='Sep',3,

if (month_fld='Oct',4,

if (month_fld='Nov',5,

if (month_fld='Dec',6,

if (month_fld='Jan',7,

if (month_fld='Feb',8))))))))

Regards,

Abey

Re: Sort Months

Thu, 12 Sep 2013 10:52:38 GMT

i have 2 month fields month1,month2 and 2 year fields year1,year2.

Also, the user may select another period next time may select for example from may 2013 to mar 2014 and so on

Re: Sort Months

Anonymous — Thu, 12 Sep 2013 11:32:13 GMT

Hello Mona,

which dimension month are using to plot your chart? Month1, month2 or another one?

Re: Sort Months

ecolomer — Sun, 31 Aug 2014 06:18:11 GMT

Here you have an example

Sorry, because my QV is in Spanish.