topic hide and active sheet object while making selection? in QlikView

hide and active sheet object while making selection?

Anonymous — Sat, 17 Dec 2016 02:57:58 GMT

Hi experts,

I want to enable my current selection box when any selection made in sheet, rest of time it should hide. What is the way to do that help on it .

Thanks & Regards

Pavan

vishsaggi — Sat, 17 Dec 2016 03:55:45 GMT

Create a variable vShow. Like

LET vShow = IF(Getcurrentselections() >0, 1,0);

Then in any sheet object properties -> Go to Layout Tab -> check conditional and type =vShow

I hope this would work.

Anonymous — Sat, 17 Dec 2016 04:19:32 GMT

Hi vishwanath,

Thank u, but my requirement is initially current selection box should be hide, when made selections it would be active show.

sudhir0538 — Sat, 17 Dec 2016 05:05:57 GMT

Hi Pavan

Replace the variable definition with this logic

"=if(count(GetCurrentSelections())>0,1,0)" and go to current selection box properties --> layout ---> show---> conditional

and write vShow=1.

I'm sure it'll work.

Anonymous — Sat, 17 Dec 2016 10:56:28 GMT

Hi sudhir its perfectly working. Thanx on ur work.