topic Pick function. in QlikView

Pick function.

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

In the dimension I have a value list ('WP','LY','LLY','LLLY','WP vs LY','LY vs LLY','LLY vs LLLY'). In the expression I'm using pick function based on derived expression as show below. I want to do the subtraction of WP header and LY header. Is it possible?

=Pick(Match($(vReportHeader),'WP','LY','LLY','LLLY','WP vs LY','LY vs LLY','LLY vs LLLY'),

([ITP (Total)]-[AUR (FP/POS)])/[ITP (Total)],

([ITP (Total)])),

([ITP (Total)]-[AUR (FP/POS)]),

([ITP (Total)]-[AUR (FP/POS)]))

Re: Pick function.

vishsaggi — Fri, 07 Jul 2017 21:04:34 GMT

Are you getting any issue when you use this function? What expression are you using in your vReportHeader?

May be use quotes around the variable like?

Match( '$(vReportHeader)', ....

Re: Pick function.

Anil_Babu_Samineni — Sat, 08 Jul 2017 01:23:13 GMT

Where you want subtraction need?

May be this?

=Pick(Match($(vReportHeader),'WP','LY','LLY','LLLY','WP vs LY','LY vs LLY','LLY vs LLLY', ValueList('WP - LY')),

([ITP (Total)]-[AUR (FP/POS)])/[ITP (Total)],

([ITP (Total)]),

([ITP (Total)]-[AUR (FP/POS)]),

(([ITP (Total)]-[AUR (FP/POS)])/[ITP (Total)] - ([ITP (Total)]-[AUR (FP/POS)])/[ITP (Total)]),

)