Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hiya
sorted x
used if([Arrival Month]='Jan',1,...if([Arrival Month]='Feb',2, and so on and solved the issue.
Kind Regards
Joeybird
I usually let the months sort themselves out. Can you try to explain why that doesn't work for you?
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
No idea. It's meaningless to me without context. I've never encountered a month 'A' before.
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
Hiya
sorted x
used if([Arrival Month]='Jan',1,...if([Arrival Month]='Feb',2, and so on and solved the issue.
Kind Regards
Joeybird