Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vardhancse
Specialist III
Specialist III

How to restrict selections for only single sheet in qlikview

Hi,

I have a requirement is that, All the selections done in one sheet should be restricted to that one sheet only.

i.e, it should not reflect on another sheet.

Came to know that by using alternate state we can achieve that.

Can any one help me out to get the same.

Thanks & Regards,

Sasi Vardhan KV

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Well alternate state is the best way to achieve this, but you can also do this with the sheet activate and sheet de-activate triggers:

  • On sheet activate, save the current selections in a bookmark (use a bookmark specially created for this and the                 replace bookmark action)      
  • On sheet de-activate, replace the selections made on the sheet with the bookmark.
  • If you want the special sheet selections to remain, use another bookmark with the reverse of the above on the triggers

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

4 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Well alternate state is the best way to achieve this, but you can also do this with the sheet activate and sheet de-activate triggers:

  • On sheet activate, save the current selections in a bookmark (use a bookmark specially created for this and the                 replace bookmark action)      
  • On sheet de-activate, replace the selections made on the sheet with the bookmark.
  • If you want the special sheet selections to remain, use another bookmark with the reverse of the above on the triggers

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

To create alternate state,

Go to Document Properties window, in the General tab you can find the button called "Alternate States", click that and Add "Sheet1", Sheet2, etc., till the no. of sheets you have in ur application.

Then in each sheet, go to the property of each object and in General tab select the sheet name in the "Alternat State" drop down box.

This will achieve your need.

Not applicable

Give your sheet an alternatestate. Then other sheets wont be affected

NOTICE: You cannot use $sign in your set analysis.

Not applicable

Hi All,

I need help here to assign two alternate state in one sheet.

I have created two alternate state =  state_1,state_2

Total 6 charts and various field list

Eg:

Say I have a two field list say Country , Business Unit

Case 1 : If i assign state_1 for Country field and state_1 for Chart 1  which means if we select Country field its going to change Chart 1 only

Case 2: If i also assign state_2 to Country field & Business Unit and state_2 for Chart 1  + Chart 2 here if you select country field and business unit - Chart 1 & 2 has to change

Here Chart 1 and Chart 2 has intersection of states (both state_1 & state_2) where as it gives me to choose only one state

Is it possible ? If so how ?