topic Current selection restriction in QlikView

Current selection restriction

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

I want to restrict current selection to particular sheet. do we have any option to implement this other than Alternate state.

Am not using current selection box its a text object with GetCurrentSelections().

Thanks,

Divya

Re: Current selection restriction

nagarjuna_kotha — Tue, 28 Feb 2017 09:24:19 GMT

you can by pass the selections in particular field using set analysis

-Nagarjun

Re: Current selection restriction

nagarjuna_kotha — Tue, 28 Feb 2017 09:26:45 GMT

can you explain clearly, you want hide particular object in particular sheet or you want restrict the selections in particular field and sheet?

-Nagarjun

Re: Current selection restriction

qdivyact — Tue, 28 Feb 2017 09:32:39 GMT

I have two sheets SH01 & SH02 and GetCurrentSelections() text object in both sheets. Now the selections made in SH01 should not be displayed in SH02 GetCurrentSelections() and vice versa.

Re: Current selection restriction

nagarjuna_kotha — Tue, 28 Feb 2017 10:18:56 GMT

how you are going to sheet 1 and sheet 2 , are you using action type action or directly selecting ur sheets?

If you are using active sheet action , then add one more action clear all action

or else

Direct add for both seets

Properties>>triggers>>OnActiveSheet>Add clearll action in the both the sheets

-Nagarjuna

Re: Current selection restriction

buzzy996 — Tue, 28 Feb 2017 10:35:02 GMT

Just do the same on both the sheets

Re: Current selection restriction

avinashelite — Tue, 28 Feb 2017 10:49:37 GMT

Any reason you don't want to go with the Alternate state ? because it could be easily achieved using applying the Alternate state on the whole sheet so that it won't effect the other.

Otherwise you need to go with the Sheet Triggers and clear the selection but when you go back to sheet 1 you won't get the selection made !! but if you use the Alternate state you would retain the selection in the sheet 1 also

Hope this helps you

Re: Current selection restriction

qdivyact — Wed, 01 Mar 2017 05:47:08 GMT

Hi all Thanks for your response !

I am going with Alternate state itself as i have to retain the selections on switching to other sheet. More over the requirement is to segregate one set of sheets from other, Say SH01 to SH10 should have one set of selections and current selection should be visible in all the 10 sheets & SH11 to SH20 should have other set of selections current selection should be visible in the other 10 sheets.

Thanks again !

Re: Current selection restriction

avinashelite — Wed, 01 Mar 2017 09:50:45 GMT

ok please mark the correct and helpful answers and close this thread