Discussion board where members can get started with QlikView.
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,
Go to Solution.
May be this
Pick(Match(Field, 'DS', 'LD', 'TS'), 'Load Discharge', 'Local Discharge', 'Tran-shipment')
create the variable and use them
set DS= Load Discharge etc.
In load script create derived column based on acronyms using Applymap function.
Load * inline[
Load *, ApplyMap('MappingTable',sCode,'Default value') as CodeDesc;
Id , sCode
Thanx for quick reply.