topic Re: Rename variable's value in Qlikview in QlikView

Rename variable's value in Qlikview

Fri, 11 Jul 2014 02:16:52 GMT

Hi All,

I am trying to rename to the variable's values in Qlikview. May I know how to go about doing it? I had tried using "if" and "Rename" function but it doesn't seems to work.

For example

Original

Desired Output

Mon

Tue

Wed

Thu

Fri

Mon

Tue

Wed

Thu

Fri

Fruits

apple

orange

banana

pear

grapes

Fruits

My expression:

if(Fruits='apple','1') or

if(Fruits='orange','2') or

....

if(Fruits='grapes','5')

Re: Rename variable's value in Qlikview

Fri, 11 Jul 2014 02:33:15 GMT

I am not sure what you are trying to do. Do you want to rename the values during the script loading? Also, do you only have a few values (i.e. like 5-6) that you want to convert to numbers?

One approach might be do use WildMatch() like this:

LOAD WildMatch(Fruits,'apple','orange','banana','pear','grapes') as Fruits

FROM Table;

If Fruits = apple, WildMatch will return a 1

If Fruits = orange, WildMatch will return a 2

and so on...

Re: Rename variable's value in Qlikview

Fri, 11 Jul 2014 02:44:13 GMT

Hi Lior,

Thanks for your reply. I am actually try to rename the variable values into names easier read by user. The initial variable value is a code X82-123 which I want to rename to be easier read value "apple".

I do not want to convert to number. I had around 15 values to convert.

Best regards,

Andy

Re: Rename variable's value in Qlikview

Fri, 11 Jul 2014 02:46:37 GMT

Otherwise, if you are just looking for a nested if-statement expression to evaluate the 'Fruits' text to numeric, you can do something like this:

If(Fruits = 'apple', 1,

If(Fruits = 'orange', 2,

If(Fruits = 'banana', 3,

If(Fruits = 'pear', 4,

If(Fruits = 'grapes', 5)))));

Re: Rename variable's value in Qlikview

Fri, 11 Jul 2014 02:56:12 GMT

Thanks Lior!! It works now!

Cheers,

Andy

Re: Rename variable's value in Qlikview

Fri, 11 Jul 2014 02:56:23 GMT

You may want to look into ApplyMap(). You can load or create a table of code -to- friendly values.

For example:

// Code to Friendly values:

Map_Fruits:

Mapping LOAD * Inline

[

Code,Values

1,apple

2,orange

3,banana

4,pear

5,grapes

];

// ApplyMap when you load your data:

YourTable:

LOAD ApplyMap('Map_Fruits', Fruits) as FriendlyFruits

FROM Table;