topic Re: Arrange Month Names on Slider in QlikView

Arrange Month Names on Slider

ksomosera10 — Thu, 10 Aug 2017 00:57:42 GMT

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!

Re: Arrange Month Names on Slider

techvarun — Thu, 10 Aug 2017 02:11:50 GMT

Would you mind posting a sample app here?

Thanks,

Varun.

Re: Arrange Month Names on Slider

Anil_Babu_Samineni — Thu, 10 Aug 2017 02:37:00 GMT

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

Re: Arrange Month Names on Slider

techvarun — Thu, 10 Aug 2017 02:43:33 GMT

Sort by Load Order might work

Re: Arrange Month Names on Slider

jonathandienst — Thu, 10 Aug 2017 05:08:41 GMT

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

Re: Arrange Month Names on Slider

Thu, 10 Aug 2017 06:06:47 GMT

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.

Re: Arrange Month Names on Slider

Anonymous — Thu, 10 Aug 2017 06:22:51 GMT

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

Below is the script and screenshot.

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;