topic Re: Calculated expression in QlikView

Calculated expression

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

Hi:

Is there any way to do this:

I just want to be able to put a comment on the expression side. This is a pivot.

I want to put this on the expression side.

I tried to use pick/match put it didnt work.

Thanks,

Re: Calculated expression

MK_QSL — Sat, 07 Jan 2017 17:06:49 GMT

IF(DAY = '14.Fri' and Location_Description = 'Central','$465')

Re: Calculated expression

vinieme12 — Sat, 07 Jan 2017 18:40:54 GMT

Try as below

=IF(DAY = '14.Fri' ,Pick(Match(Location_Description,'Central','West'),'$465','$500'))

Re: Calculated expression

girirajsinh — Sat, 07 Jan 2017 19:57:38 GMT

HI Joe

If I have understood your question right ? would following arrangement at script level solve your issue ?

temp_table:
LOAD * INLINE [
F1, F2, F3
14.Fri, central, 634
14.Fri, west, 466
14.Fri, east, 681
14.Fri
];

map_table:
mapping LOAD * Inline
[
input_F1, map_F2,
14.Fri-central,465
14.Fri-west, 500
14.Fri-east, 800

];

main_table:
LOAD
F1,
F2,
F3,
ApplyMap('map_table',F1&'-'&F2) as Comment
Resident temp_table;

DROP Table temp_table;

Then use the Comment field in Pivot table.