Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
New in Qliksense after several year with Qlikview...
A simple applymap which work in QV don't work in QS Why
TOTRANSLATE:
Mapping LOAD * INLINE [
FactCode, FACTNAME
01, A
04, B
A9,C
B0, D
];
When I apply, it works properly for A9 & BO but not for 01, 04 Why ?
I use
applymap('TOTRANSLATE',Code) as NewCode;
Thansk for, your help, not so easy to go frm qlikview to Qliksense !
As far as i know there is not difference in Mapping load or applymap between qlikview and sense. i tried to simulate with simple example below and it works.
I suggest you look at the data in your Code column.
TOTRANSLATE: Mapping LOAD * INLINE [ FactCode, FACTNAME 01, A 04, B A9,C B0, D ]; load *, applymap('TOTRANSLATE',Code) as NewCode; load * inline [ Code 01 04 A9 B0 ];
Most probably the data in your Code field has different formatting, e.g. text or half text and half numbers or 01 might be loaded as 1, etc. Check that field.