Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Hi Kumar,
Thank You. So Much.
Best Regards
HK