Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
i need small clarifaction,you want to clear for all selection or only for single list box.
Regards
SHAIK
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.
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
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
hiii
right click on sheet properties in Trigger tab
add action OnActivesheet ClearAll
and same add action for ONLeaveSheet
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.
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.
Gr
Frank
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
Hi,
I believe that for this to work you would have to have two different scenarios, and without totally different related fields.
Rebeca