topic Re: Sheet tab de-selection in QlikView

Sheet tab de-selection

Mon, 28 Apr 2014 13:57:39 GMT

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

Re: Sheet tab de-selection

MK_QSL — Mon, 28 Apr 2014 14:01:10 GMT

You can achieve by using alternate state in qlikview.

Try to search on alternate state...

Re: Sheet tab de-selection

its_anandrjs — Mon, 28 Apr 2014 14:02:34 GMT

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)

Re: Sheet tab de-selection

Mon, 28 Apr 2014 14:08:35 GMT

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

Re: Sheet tab de-selection

eduardo_sommer — Mon, 28 Apr 2014 14:13:20 GMT

You need to use alternate states. With alternate states you can have different selections between tabs or even between objects in the same tab.

Re: Sheet tab de-selection

antoniotiman — Mon, 28 Apr 2014 14:25:20 GMT

You can set Alternate State in the full sheet. See Property of Sheet -> Alternate State

Re: Sheet tab de-selection

Roop — Mon, 28 Apr 2014 14:26:02 GMT

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.

Re: Sheet tab de-selection

Colin-Albert — Mon, 28 Apr 2014 14:29:55 GMT

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.

Re: Sheet tab de-selection

Mon, 28 Apr 2014 14:37:52 GMT

Its not possible to use triggers to avoid this,,, can any one reply

Re: Sheet tab de-selection

aveeeeeee7en — Mon, 28 Apr 2014 14:40:48 GMT

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