topic Change month number to name NOT in SQL but in list box in QlikView

Change month number to name NOT in SQL but in list box

Wed, 30 May 2012 19:45:57 GMT

I have an inherited SQL script that works fine to give me a field "Month", which contains 1-12. Naturally, on reports, I'd prefer to show the month name. First, I tried doing it SQL, but the result was the month names (fine), but in a random order. No matter what I picked in the "Sort" property in the list box, they wouldn't come up in month order (alphabetical? sure. state? sure. but calendar order? No.) Within the "Month" (number) list box, I tried the expression = Pick(Month, $(MonthNames)) but that didn't change it. Is there away to do this in the Listbox and not in SQL?

Change month number to name NOT in SQL but in list box

yvesqlik — Wed, 30 May 2012 20:11:02 GMT

bevoryou load your data from sql, you have to create a dual

load dual(String,Num) as Month inline

[String,Num

Jan,1

Fev,2

Mar,3

Apr,4

Mai,5

Dec,12

];

here you can load you data and use the fied Month.

und now you can use the name of month in your listbox.

Let me know if my solution help can help u.

best regards

Change month number to name NOT in SQL but in list box

Wed, 30 May 2012 20:31:35 GMT

Thanks, yves, that worked just fine.