topic Re: List Box 'Month' Picker.... Hel in QlikView

List Box 'Month' Picker.... Hel

prees959 — Sat, 16 Nov 2024 21:36:29 GMT

Hi,

I currently have a horizontal Month picker :

Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb

Is there anyway to set the list box to use the 'Month Initial' and keep the sort order of March - April , eg:

M | A | M | J | J | A | S | O | N | D | J | F ?

Thanks,

Phil

sunny_talwar — Mon, 14 Jan 2019 13:00:42 GMT

May be try this as your expression

Dual(Left(Month, 1), Month)

and sort using the following expression

Pick(Month, 11, 12, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10)

prees959 — Mon, 14 Jan 2019 15:42:13 GMT

Thanks!!!
Perfect!

sunny_talwar — Mon, 14 Jan 2019 16:05:37 GMT

Actually change the sort expression to this

Pick(Only({1} Month), 11, 12, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10)