topic How do I show a number as a Text counterpart ? in QlikView

How do I show a number as a Text counterpart ?

Tue, 25 Nov 2014 11:42:21 GMT

Hello ,

I have a simple list box and added one field from a SQL database. On display, the box shows 3 rows ;

I would like to display BIRD instead of 1, CAT instead of 3 and DOG instead of 20 . Maybe I can use an expression ? Like match('1' , Fieldname, 'BIRD') or something ?

Re: How do I show a number as a Text counterpart ?

PrashantSangle — Tue, 25 Nov 2014 11:48:00 GMT

Hi,

Create Inline table

Write in script

* INLINE [
    num, Value
    1, Bird
    3, Cat
    20, Dog
];

Then use Value as List box

Or you can handle it on front end

create list box with expression

if(wildmatch(num,'1'),Bird,if(wildmatch(num,'3'),'Cat',if(wildmatch(num,'20'),'Dog')))

Regards

Re: How do I show a number as a Text counterpart ?

jagan — Tue, 25 Nov 2014 12:08:53 GMT

Hi,

Try this in script

LOAD

* ,

Pick(Match(num, 1, 2, 20), 'Bird', 'Cat', 'Dog') AS NewField

INLINE [
    num
    1
    3
    20
];

Hope this helps you.

Regards,

Jagan.

Re: How do I show a number as a Text counterpart ?

Tue, 25 Nov 2014 12:29:46 GMT

This was what I needed and it works :

if(wildmatch(num,'1'),'Bird',if(wildmatch(num,'3'),'Cat',if(wildmatch(num,'20'),'Dog')))

Many thanks @max dreamer

Re: How do I show a number as a Text counterpart ?

jagan — Wed, 26 Nov 2014 01:59:26 GMT

Hi,

Why using 3 ifs and 3 WildMatch(), simply use one WildMatch() and one Pick(), what if you have 50 number? will you include 50 If() and 50 WildMatch()?

=Pick(WildMatch(num, 1, 3, 20), 'Bird', 'Cat', 'Dog')

Hope this helps you.

Regards,

Jagan.

Re: How do I show a number as a Text counterpart ?

Wed, 26 Nov 2014 07:38:16 GMT

this is much easier , thanks jagan mohan