topic Re: Qlik Sense Sorting Months (string) in order in Visualization and Usability

Qlik Sense Sorting Months (string) in order

deec — Tue, 25 Aug 2015 17:38:15 GMT

Is there a way to do a custom sort in sense?

I did not see "original load order" as one of the options to sort this, so even if I created an inline to preload these strings, I don't think sense has that capability. Does it?

I have strings 'Jan','Feb',...

My only guess is that I'll need to use my actual date field '1/1/1900' format, and extract the month names from it. What say you, community?

Re: Qlik Sense Sorting Months (string) in order

ramoncova06 — Tue, 25 Aug 2015 17:51:50 GMT

you could create a dual and then sort by number

something like Dual(Month,num(Month))

Re: Qlik Sense Sorting Months (string) in order

ogster1974 — Wed, 26 Aug 2015 22:33:49 GMT

‌you could create a master calendar for your dashboard And include a Fiscal month number value in it and sort on that value by using sort by expression in your chart. That way you can be flexible in ordering by calendar year or fiscal year.

Regards

Andy