topic Expression in QlikView

Expression

dhanavindhan — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Expression

sunny_talwar — Tue, 13 Feb 2018 17:49:32 GMT

May be this

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

Re: Expression

vinod22kv — Tue, 13 Feb 2018 17:53:57 GMT

create the variable and use them

set DS= Load Discharge etc.

Re: Expression

akshaye_c_navale — Tue, 13 Feb 2018 17:56:29 GMT

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

];

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

Load * inline[

Id , sCode

1,DS

2,LD

3,TS

];

Thanks,

Akshay

Re: Expression

dhanavindhan — Wed, 14 Feb 2018 04:21:51 GMT

Thanx for quick reply.

Re: Expression

dhanavindhan — Wed, 14 Feb 2018 04:22:44 GMT

Thanx Sunny.