topic Association in QlikView

Association

manishapanda1 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

can some one please help me to understand how stop association between 2 Sheets :

eg :

i have 2 sheets in may proj in sheet1 i have mentioned a details table view, and current selection box

and in 2nd sheet i have list box and multi box for selection and straight table , but when i am doing any selection in sheet2 ,sheet1 data also get filter ,

i want solution like if i do any selection in sheet2 then only that sheet should give the result , rest other sheets data should not change.

2 )

and i want the same data section control in between 2 tables as well.

like i have table 1 and table 2 if i filter some data in table1 then that should only respond , table 2 should remain unchanged.

Thanks ,

Manisha P

Re: Association

sergio0592 — Wed, 10 Oct 2018 19:00:38 GMT

Hi,

1) Use alternate state for this. In your set analysis :

sum({Alterate_state_name <Year={"XXX"} > Sales)

2) For cancel selection effect use. eg, with a chart with Product/Sales if you don't want that selection on Product has an effect on your chart :

sum({$<Product>} Sales)

Re: Association

jayanttibhe — Wed, 10 Oct 2018 19:03:27 GMT

For Scenario -1

You need to define Alternate States at Sheet Level

For Scenario -2

You need to define Alternate States at Object Level

Re: Association

chrismarlow — Wed, 10 Oct 2018 19:04:36 GMT

So the global applicability of selections has always been presented to me as one the central things to QlikView. That said there are options, you could potentially use alternate states (& think you would need to for the charts on the same sheet);

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Alternate%20States.htm

Otherwise macro actions as you navigate between the sheets (Sheet Properties - Triggers).

Regards,

Chris.