Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,all in a sheet we use many tabs ,if we select any thing in one tab that selection will reflects to all the tabs in a sheet ,but i need reflect the selection in only one tab ,how can we do this ,please reply
You can achieve by using alternate state in qlikview.
Try to search on alternate state...
This is the association property of the qlikview when you select any entity in and field the association based on the entity will reflect on all the related fields. If you want to avoid this you can use SET analysis for this like
In any chart Sum({<Year=, Month=>} Value)
And in another chart where you want reflection then use only
Sum(Value)
Alternate state is usefull for only a sheet object ,but i need entire sheets ,let me give clarity we have India,pak,aus as 3 sheets ,if we select 2014 income in india ,same 2014 income of pak,aus also reflect as green, what i want is if i select in india tab only india tab should be green ,will you help to do this
You need to use alternate states. With alternate states you can have different selections between tabs or even between objects in the same tab.
You can set Alternate State in the full sheet. See Property of Sheet -> Alternate State
I understand where you are coming from and also understand Anand's point about the association property of QlikView.
The only real way that I can think of (and it is a bit messy) is to use a button to select each of your dimensions. The action of the button would be to clear all selections, make all listbars except required invisible, and then the user can select that particular listbar.
Although it is messy, it means that all listbars can use the same space on the screen and so would minimise the space requirement for menu etc.
This is one of the fundamental properties of QlikView - there is only one data set behind the whole application.
If you make a selection on any sheet, that selection still applies when users change sheets until the selection is changed or cleared.
It is better to train your users to understand how the data selections in QlikView work across the whole application, rather than creating a non-standard workaround.
Its not possible to use triggers to avoid this,,, can any one reply
Hi Uday
Colin Is Right.
There is a way, you can do it by using Triggers - "Clear All"
or for each sheet, keep the Data Model separate. Don't Link the Data.
It will work for you.
Regards
Aviral