topic Re: Pick Function not working when selecting dimensions in QlikView

Pick Function not working when selecting dimensions

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

HI ,

Can Some one help me here about pick function in Qlikview.

In pick function when i select any of my geography like WW or region my targets column is missing in the QVW.

if i try with out pick function my targets are working as expected.

For Your Reference i am attaching my Qlikview application.

qliksus — Tue, 25 Sep 2018 03:40:08 GMT

Just replace your pick function like the below.

Pick( ( if( isnull(Dim),1,Dim) ) , ...

The reason is when the region is selected there is no Target value which is not returing the corresponding value in the field Dim

dunnalahk123 — Tue, 25 Sep 2018 04:53:23 GMT

Hi Kumar,

Thank You. So Much.

Best Regards