topic Re: How can I Disconnect Different Objects in QlikView

How can I Disconnect Different Objects

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have 2 tabs, each of the tab have different objects. When I the object from Tab1, the data would change in other object on Tab 2. If I don't want to the result change on Tab2, how can I do it?

Thanks in advance,

Becky

Re: How can I Disconnect Different Objects

Wed, 27 Jul 2016 19:07:44 GMT

On simple table is not possible. but you make on dinamic table witc {<field,field,fiel>} or {1}

Re: How can I Disconnect Different Objects

Wed, 27 Jul 2016 19:22:03 GMT

Hello Yun,

You can try to achieve that using set analysis or alternate states.

First option will require changing expressions in both objects, and some knowledge (please refer to this document: Set Analysis: syntaxes, examples

Second option requires you to set different State to each of the objects. (please read more here: https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Alternate%20States.htm)

I also have written short blog post about those: Alternate states - easy data comparisons - QlikPad.com

BR,

Kuba

Re: How can I Disconnect Different Objects

Wed, 27 Jul 2016 20:50:58 GMT

Thank you Kuba.

I tried set up two different states. And assign each object in Tab1 to State1, each object in Tab2 to State 2.

But for some reason, only one object remain the same value in Tab1 after I clicked in Tab2. I am not sure why this happened.

Re: How can I Disconnect Different Objects

Wed, 27 Jul 2016 20:52:20 GMT

Thanks Rodrigo. Do you know if there a post could give more deail about make dynamic table and write {<field,field,fiel>} or {1}. I have no clue how it is...

Re: How can I Disconnect Different Objects

Thu, 28 Jul 2016 13:06:20 GMT

I know why that assign state sometime didn't apply to certain objects. It seems like set analysis and assign state cannot use at the same time.

Re: How can I Disconnect Different Objects

Thu, 28 Jul 2016 13:13:18 GMT

folow example

Re: How can I Disconnect Different Objects

Thu, 28 Jul 2016 15:37:29 GMT

Hello again yun,

It can be used together You must use a proper set identifier (name of alternate state) - read more here: http://www.qlikfix.com/2014/08/12/alternate-states/

BR,

Kuba