QlikView App Dev

[ksomosera10]

Hi,

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

This values comes from a script

Month(date) as months

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

Thanks in advance!

[techvarun]

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

[techvarun]

Sort by Load Order might work

[jonathandienst]

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

[#6]

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.

[Anonymous · Accepted solution]

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;