List Box Display

[#1]

Hey guys,

I have a table of data in my qlikview document.  When I make a listbox for this data, the numbers: -1,0,1,3, and 4 are displayed.  If I want to make it say "Pre-Release" instead of -1 and different phrases corresponding with each number, what do I do?

I have:   

-1

0

1

3

4

I want:

Pre-Release

Staged

Released

Closed

Cancelled

Thanks for the help!

[#2]

You can either use an IF condition or put it in the scrupt.  I recommend using an Inline or mapping load in the script.

[Bill_Britt · Accepted solution]

Hi,

You can do something like this

LOAD * INLINE [

    Field, Field1

    -1,Pre-Release 

    0, Staged

    1, Release

    2, Closed

    3, Cancelled

];

With Field matching the original field name and Field1 being a new name

Bill

[rustyfishbones]

you can create a Mapping Load from an inline table and then you use Applymap on the table that contains the numbers

[#5]

You can do it in the back-end using Mapping inline table. See attached

Hope it helps

[preminqlik]

hi try this

Load *,

if(match(field,-1),'Pre-released',field)                    as               NewRequiredField

from path;

[#7]

Thanks guys!