topic Re: Sort order "months" on Combo chart in App Development

Sort order "months" on Combo chart

joeybird — Mon, 18 May 2015 15:26:52 GMT

Hiya

does anyone know hoe to sort months on a combo chart...

Qlik Sense... even tried moving the order of dimensions and no joy

have tried descending, ascending, numeric and even the following as an expression

if([Arrival Month]='Jan',1,if([Arrival Month]='A',2,3))

Oct is second and Feb is last

does anyone know how to fix it please?

Kind Regards

Joeybird

Re: Sort order "months" on Combo chart

Gysbert_Wassenaar — Mon, 18 May 2015 15:50:38 GMT

I usually let the months sort themselves out. Can you try to explain why that doesn't work for you?

Re: Sort order "months" on Combo chart

joeybird — Mon, 18 May 2015 16:24:58 GMT

Hiya

no idea...sorting works fine if a bar chart...but combo chart no...tried everything...

i can order by alphabetically that works, but not numerically

is there away of amending the expression below to sort months

if([Arrival Month]='Jan',1,if([Arrival Month]='A',2,3))

or a straight forward order by "expression" for months please?

Kind regards

joeybird

Re: Sort order "months" on Combo chart

Gysbert_Wassenaar — Mon, 18 May 2015 16:31:52 GMT

No idea. It's meaningless to me without context. I've never encountered a month 'A' before.

Re: Sort order "months" on Combo chart

Mon, 18 May 2015 23:14:48 GMT

Hi Joanna,

I am a new user to QlikSense, so may have this totally wrong or be oversimplifying, but I recently posted a similar question for bar charts and discovered two things that helped me get months shorted chronologically:

1. Don't load month and year data separately from your data source. Load a single date that includes month and year and order by this dimension (by dragging it to the top of your list in the 'data' menu of QlikSense).

2. If you are loading data from Excel, you will need to translate Excel's serial number format into something usable in QlikSense. I used the formula date#(date(InvDate, 'MMM-YYYY'), 'MMM-YYYY') as Date which gave me my loaded dates but with just the Month and Year (no Day) and the correct ordering. InvDate is the name of my Excel data field that contains the date I wanted.

My question is posted here if you want to check it out: How do I order months in a bar chart chronologically in QlikSense?

I hope this helps!

Erin

Re: Sort order "months" on Combo chart

joeybird — Wed, 20 May 2015 09:34:13 GMT

Hiya

sorted x

used if([Arrival Month]='Jan',1,...if([Arrival Month]='Feb',2, and so on and solved the issue.

Kind Regards

Joeybird