topic Re: pick(match) in QlikView

pick(match)

krish2459 — Sat, 16 Nov 2024 18:21:45 GMT

Hi,

I'm trying to write below condition

pick(match(MvT, '711','712','713'),'711','712','713')

but I'm getting out as

711 and 712

713 is missing.

Help me to get this.

Thanks..

Re: pick(match)

nevilledhamsiri — Wed, 15 Jul 2020 18:10:43 GMT

Try This out,

pick(match(MvT, '711','712','713') +1, 'No', 'Yes') As mvt_flag

This way, Yes will carry the said numbers .

Re: pick(match)

sunny_talwar — Wed, 15 Jul 2020 19:31:45 GMT

What exactly is the use of Pick Match here? MvT and the new field created will always be the same, right? because 711 is mapped to 711, 712 is mapped to 712 and 713 to 713