topic Re: List Box Display in QlikView

List Box Display

Mon, 12 May 2014 17:57:59 GMT

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

I want:

Pre-Release

Staged

Released

Closed

Cancelled

Thanks for the help!

Re: List Box Display

Mon, 12 May 2014 18:01:59 GMT

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

Re: List Box Display

Bill_Britt — Mon, 12 May 2014 18:08:00 GMT

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

Re: List Box Display

rustyfishbones — Mon, 12 May 2014 18:08:16 GMT

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

Re: List Box Display

Mon, 12 May 2014 18:10:41 GMT

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

Hope it helps

Re: List Box Display

preminqlik — Mon, 12 May 2014 18:15:47 GMT

hi try this

Load *,

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

from path;

Re: List Box Display

Mon, 12 May 2014 18:17:24 GMT

Thanks guys!