Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to sort month

Hi,

Have a look at the attached and see if you have a solution?

Thanks.

10 Replies
maneshkhottcpl
Partner - Creator III
Partner - Creator III

Hi,

Please refer the attached application.

Right CLick - MonthField--Sort--Remove all sort check boxes

Not applicable
Author

Thanks Manesh for the suggestion.

But it is not working for me. We need to have a sort.

Other alternatives?

suniljain
Master
Master

You need sort based on Fiscal or Calendar Year ?. Because Your Inline have Month Sequence based on Fiscal Year

francisvandergr
Partner - Creator II
Partner - Creator II

Ha,

Inline table like

01 jan

02 feb

03 maart

nz

Not applicable
Author

yup... this is the solution, at the start of the script, load the month and their number in sequence... then, later part in the listbox, just sort this field by LOAD sequence.

It seems like the sort by expression will only work if it's static, once it's click, the sequence goes wrong.

Stefan_Walther
Employee
Employee

Just use a normal Date field (using a dual type) and sort it by the numeric value, then this would work ...

Hope this helps!

Regards
Stefan

maneshkhottcpl
Partner - Creator III
Partner - Creator III

Hi,

Can u explain ur need in more details?

Regards

Manesh

Anonymous
Not applicable
Author

Hello ... I am facing the same problem. Did you find the right solution?

Thanks in advance

Anonymous
Not applicable
Author

Hello, In your example the sort option that worked fine is to sort by "loaded order" (the last option).

Other options I have tried are do not work properly, it does not respect the order... strange.

Hope it helps,

Javier