topic Re: Alias for list box. in QlikView

Alias for list box.

Thu, 28 Jun 2012 05:20:40 GMT

i need to display a column in the list box. the column contains values like

Month id

-------------

but instead of numbers, i need to show them as a month format. for eg. JAN for 1 and FEB for 2. I should not use some other columns in the list box, because month id am using that in calculation. Any ideas how to give aliasing here..

Thanks in advance,

Praveen.

Re: Alias for list box.

giakoum — Thu, 28 Jun 2012 05:31:13 GMT

Use a list box with expression Month(Month id) instead of field.

It is the last option in the Field drop down.

Re: Alias for list box.

Thu, 28 Jun 2012 05:33:25 GMT

You can use the Inline function to achieve this. Please find the code below.

LOAD * INLINE [
Monthid, MonthName

1, Jan

2, Feb

3, Mar

4, Apr

5, May

6, Jun

7, Jul

8, Aug

9, Sep

10, Oct

11, Nov

12, Dec

];

After loading this map the MonthName to the list box. Both Month id and Month name will be available and you can use the month id for calculation too. Hope this will help you.

Re: Alias for list box.

sivarajs — Thu, 28 Jun 2012 07:12:28 GMT

try this

Date(Date#(Month id,'MM'),'MMM') in expression of list box

Regards

Sivaraj

Re: Alias for list box.

Thu, 28 Jun 2012 10:26:13 GMT

thanks sivaraj, it worked for me!!!