Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
dhanavindhan
Contributor

Expression

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

1 Solution

Accepted Solutions

Re: Expression

May be this

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

5 Replies

Re: Expression

May be this

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

Highlighted
vinod22kv
New Contributor III

Re: Expression

create the variable and use them

set DS= Load Discharge etc.

itsakshaye
New Contributor III

Re: Expression

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
Contributor

Re: Expression

Thanx for quick reply.

dhanavindhan
Contributor

Re: Expression

Thanx Sunny.

Community Browser