Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
ksomosera10
Creator II
Creator II

Arrange Month Names on Slider

Hi,

Just want to know how I can arrange these Month names on the slider?

slider.JPG

This values comes from a script

Month(date) as months

so I'm having difficulty knowing how to address this issue..

Thanks in advance!

1 Solution

Accepted Solutions
Anonymous
Not applicable

Use dual function in your script and in slider object user sort by numeric value.

Below is the script and screenshot.

c:

Load dual ( month,NumDay ) as DayOfWeek inline

[ month,NumDay

Jan,0

Feb,1

Mar,2

Apr,3

May,4

Jun,5

Jul,6

Aug,7

Sep,8

Oct,9

Nov,10

Dec,11

];

drop table c;slider.PNG

View solution in original post

6 Replies
techvarun
Specialist II
Specialist II

Would you mind posting a sample app here?

Thanks,

Varun.

Anil_Babu_Samineni

May be check the sort option for Text as A-Z for that Month field

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
techvarun
Specialist II
Specialist II

Sort by Load Order might work

jonathandienst
Partner - Champion III
Partner - Champion III

If they were created using Month(date), then you should be able to sort them numerically.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Hi Kevin,

     That depends on how the Month names were created. If they were created using an expression in the sheet then you can sort them numerically by ascending or descending. If the data in the source is in perfect order of month then you can simply do load by order in the properties.slider.PNG

Anonymous
Not applicable

Use dual function in your script and in slider object user sort by numeric value.

Below is the script and screenshot.

c:

Load dual ( month,NumDay ) as DayOfWeek inline

[ month,NumDay

Jan,0

Feb,1

Mar,2

Apr,3

May,4

Jun,5

Jul,6

Aug,7

Sep,8

Oct,9

Nov,10

Dec,11

];

drop table c;slider.PNG