Pick Function not working when selecting dimensions

[dunnalahk123]

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 · Accepted solution]

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]

Hi Kumar,

Thank You. So Much.

Best Regards

HK