Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qdivyact
Partner - Contributor III
Partner - Contributor III

Current selection restriction

Hi

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

1 Solution

Accepted Solutions
nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

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

View solution in original post

8 Replies
nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

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

-Nagarjun

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

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

-Nagarjun

qdivyact
Partner - Contributor III
Partner - Contributor III
Author

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.

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

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

buzzy996
Master II
Master II

Just do the same on both the sheets

avinashelite

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

qdivyact
Partner - Contributor III
Partner - Contributor III
Author

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 !

avinashelite

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