Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Alias for list box.

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

Month id

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

1

2

3

4

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.

1 Solution

Accepted Solutions
sivarajs
Specialist II
Specialist II

try this

    

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

Regards

Sivaraj

View solution in original post

4 Replies
giakoum
Partner - Master II
Partner - Master II

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

It is the last option in the Field drop down.

Not applicable
Author

Hi

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.

sivarajs
Specialist II
Specialist II

try this

    

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

Regards

Sivaraj

Not applicable
Author

thanks sivaraj, it worked for me!!!