topic Re: Trigger? in QlikView

Trigger?

khadeer — Wed, 10 Apr 2013 03:39:06 GMT

Dear All,

I have one list box. I am using this list box in two different sheets. In one sheet user can select multiple values in that list box. In another sheet he can select any one value at a time.(Always one selected value). But when i am using always one selected value in list box its reflecting on both sheet. So my need is those selections not reflect on other sheet.

User can select multiple values in one list box. For same list box when i am using in another sheet user can select single value at a time. Which trigger i have to use.

Hope i explained clearly.

Regards,

Khadeer

Re: Trigger?

Anonymous — Wed, 10 Apr 2013 04:59:43 GMT

Hi,

i need small clarifaction,you want to clear for all selection or only for single list box.

Regards

SHAIK

Re: Trigger?

Wed, 10 Apr 2013 06:37:08 GMT

Hi,

You achive your requirement by using alternate states option in qlikview:

set 2 different states for 2 listboxes and to apply these selections to charts set them also same in state.

Niranjan M.

Re: Trigger?

Wed, 10 Apr 2013 08:02:12 GMT

Hello Khadeer,

My first try would be to use something like below :

Load

List as Listbox1,

List as Listbox2

.....

Now you can use, Listbox1 in first sheet and Listbox2 in other one.

Let me know if this was helpful.

Thanks,

Angad

Re: Trigger?

danieloberbilli — Wed, 10 Apr 2013 08:36:21 GMT

Dear Khadeer,

Perhaps I missunderstood but would this help:

a) set a trigger to clear the selection of the field when user switches to the other sheet OR

b) other solution: load this field a second time in the script but rename it - so you can use one listbox on fieldX and the other on fieldX_copy

Kind regards

Daniel

Re: Trigger?

er_mohit — Wed, 10 Apr 2013 09:06:02 GMT

hiii

right click on sheet properties in Trigger tab

add action OnActivesheet ClearAll

and same add action for ONLeaveSheet

Re: Trigger?

Wed, 10 Apr 2013 09:17:47 GMT

Hi Khadeer

You can't do it.... When you switch on the property "always one selected value" this applies to the column and not to the list box object or to the sheet.

What I could suggest is that perhaps you add the column into your data model twice, then have it available in one sheet with one selected switched on, and in another sheet with one selected switched off. You could not join these two dimensions directly to your data model though, they would need to be individual data islands.

You'd then use a trigger based on the selection of either one of those columns and add a selection mechanism to make the appropriate selections against the "master" copy of that dimension.

Not straight forward, but possible.

Nigel.

Re: Trigger?

Wed, 10 Apr 2013 10:18:06 GMT

He Khadeer,

You can solve this by using alternate states. Create a alternate state and let one of the listboxes be in this alternate state. This way you don't need any triggers.

Hopes this helps.

Frank

Re: Trigger?

Wed, 10 Apr 2013 11:52:03 GMT

This is standard behaviour for Qlikview: any selection you make is reflected through the whole document, regadless of where and how the data is shown.

If you actually want what you are asking, having different selections on the same field in different sheets, you might want to use Alternate States. Alternate states can be used to group different objects that will be affected by different selections.

You can find out all about alternate states in the reference manual

Re: Trigger?

Wed, 10 Apr 2013 13:08:00 GMT

Hi,

I believe that for this to work you would have to have two different scenarios, and without totally different related fields.

Rebeca

Re: Trigger?

khadeer — Mon, 15 Apr 2013 09:52:46 GMT

Dear All,

I am using QV10 , So i can't use comparitive analysis.

I have tried to take two listboxes also. But those properties are effecting to both listboxes.

When i am using sheet triggers as clear all when leave that sheet. but its not effecting to the properties of the object. Just its clearing other selections.

Thanks for all ur replies.

Regards,

Khadeer

Re: Trigger?

Wed, 12 Nov 2014 09:53:47 GMT

It's possible to do what you want.

For that, go in Document properties, in "States" and add one state for each one of your sheets. you can call your states "Sheet1" and "Sheet 2".

Then go in your 2 sheets' properties and select the right state for each one of them.

After that, any selection done in your listbox of sheet 1 will not alter the selection of your identical listbox in your sheet 2

Here's a link which explains better what I am saying:

Using Multiple Alternate States Combined with Set Analysis to Create a Comparison Chart – Part One | resultdata