topic Value replaceable in QlikView

Value replaceable

padmanabhan_ram — Wed, 14 May 2014 09:56:15 GMT

Hi,

I have a table with Columns:

A B C

1 1 1

2 2 2

3 3 3

4 4 4

5 5 5

How can I replace the values 1,2,3,4,5 with 'NA','Bad','Avg','Good','Expert'. So that the table looks like below

A B C

NA NA NA

Bad Bad Bad

Avg Avg Avg

Good Good Good

Expert Expert Expert

Thanks,

Padmanabhan

Re: Value replaceable

padmanabhan_ram — Wed, 14 May 2014 09:57:12 GMT

Adding to the above, The Values are fixed, will never change.

Re: Value replaceable

nizamsha — Wed, 14 May 2014 09:58:02 GMT

u can use apply map

Re: Value replaceable

padmanabhan_ram — Wed, 14 May 2014 10:00:18 GMT

I Have 18 such columns like A, B, C. Will aplly map work.

Re: Value replaceable

nizamsha — Wed, 14 May 2014 10:04:15 GMT

TableB:

Mapping LOAD * Inline [

No,Name

1,NA

2,Bad

3,Avg

4,Good

5,Expert

];

TableA:

LOAD * Inline [

A , B , C

1 , 1 , 1

2 , 2 , 2

3 , 3, 3

4 , 4 , 4

5 , 5 , 5

];

TableC:

LOAD ApplyMap('TableB',A) as A1,

ApplyMap('TableB',B) as B1,

ApplyMap('TableB',C) as C1

Resident TableA;

DROP Table TableA;

Re: Value replaceable

nizamsha — Wed, 14 May 2014 10:05:58 GMT

S it will work lets see is any other giving the best solution .

Re: Value replaceable

jagan — Wed, 14 May 2014 10:09:30 GMT

Hi,

Try like this

LOAD

Pick(Match(A, 1,2,3,4,5), 'NA','Bad','Avg','Good','Expert') AS A,

Pick(Match(B, 1,2,3,4,5), 'NA','Bad','Avg','Good','Expert') AS B,

Pick(Match(C, 1,2,3,4,5), 'NA','Bad','Avg','Good','Expert') AS C

Inline [

A , B , C

1 , 1 , 1

2 , 2 , 2

3 , 3, 3

4 , 4 , 4

5 , 5 , 5

];

Regards,

Jagan.