topic Re: How to do restrict my sheet? in QlikView

How to do restrict my sheet?

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

Hi I have two sheets sheet1and sheet2.and created charts in both sheet.if I select anything in sheet1 it automatically select sheet2 also.

So my requirement is if I select any filed in sheet1 no need to reflect sheet2.my selection happen only sheet1 not sheet2.how implement.

Thanks

Chaitanya

prma7799 — Mon, 13 Nov 2017 06:59:20 GMT

Use trigger in sheet properties

Please check this

devarasu07 — Mon, 13 Nov 2017 07:04:49 GMT

Hi,

Try to configure sheet property trigger action like below screen

Siva_Sankar — Mon, 13 Nov 2017 08:14:43 GMT

Hi Chaitanya,

Right click on sheet 1--> Sheet properties window opens.

click OnLeaveSheet button-->In Action type, click Selections

In Selections-->click 'Clear All' Action and click OK.

Whatever selction you make will be cleared off when you leave sheet 1.

Find the attached screenshot for reference.

Siva