Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
ksomosera10
Contributor 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!

Tags (3)
1 Solution

Accepted Solutions
kulwantsaj219
Contributor II

Re: Arrange Month Names on Slider

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

6 Replies
techvarun
Valued Contributor II

Re: Arrange Month Names on Slider

Would you mind posting a sample app here?

Thanks,

Varun.

Re: Arrange Month Names on Slider

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
techvarun
Valued Contributor II

Re: Arrange Month Names on Slider

Sort by Load Order might work

MVP
MVP

Re: Arrange Month Names on Slider

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

Re: Arrange Month Names on Slider

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

kulwantsaj219
Contributor II

Re: Arrange Month Names on Slider

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