Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
prasannazad
New Contributor III

Locking selections of one sheet

Hi,

I have prepared a qlikview report with different sheets and ac sheet has a multibox with different selections but same variables (e.g "Headcount type" variable is common in 2 sheets but in one sheet the Headcountype selection is "Active" while in other sheet, it is "Terminations"). So, what is happening here is when i select "Active" in one sheet, the selection changes in other sheet too. How can i keep my selections specific to the sheet.

I am a qlik rookie and any help will be highly appreciated..Thanks in advance !

3 Replies

Re: Locking selections of one sheet

HI,

One way I think of is you use the OnActive Triggers available on sheet.

Using this trigger you can create an action which will select and deselect the appropriate value of the field.

Regards,

Kaushik Solanki

sergio0592
Valued Contributor II

Re: Locking selections of one sheet

Hi,

You can use alternate state in order to get differents user selection between sheets.

http://www.qlikfix.com/2014/08/12/alternate-states/

prasannazad
New Contributor III

Re: Locking selections of one sheet

Well Thank you guys! What i did is, i wrote the selections in my expression itself to avaoid any dilution

Community Browser