Expression

[dhanavindhan]

Hi Experts,

I am new to QlikView. I wanted to write a expression to bring this below output.

I have column which has the values like this (DS,LD,TS) the abbreviation for them is (Load Discharge,Local Discharge,Tran-shipment).

I wanted to populate that abbreviation instead of the acronyms. How to make them in add calculated columns. How can I write in expression to bring this output? Guide me with example.

Thanks in advance,

Dhana R

[sunny_talwar · Accepted solution]

May be this

Pick(Match(Field, 'DS', 'LD', 'TS'), 'Load Discharge', 'Local Discharge', 'Tran-shipment')

[vinod22kv]

create the variable and use them

set DS= Load Discharge etc.

[akshaye_c_navale]

Hey,

In load script create derived column based on acronyms using Applymap function.

MappingTable:

Mapping

Load * inline[

Code,Desc

DS,DS Des

LD,Load Discharge

TS,Tran-shipment

];

A:

Load *, ApplyMap('MappingTable',sCode,'Default value') as CodeDesc;

Load * inline[

Id , sCode

1,DS

2,LD

3,TS

];

Thanks,

Akshay

[dhanavindhan]

Thanx for quick reply.

[dhanavindhan]

Thanx Sunny.