Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

datagrrl
Contributor III

Alternate States One state updates the other, but not the other way.

I have a requirements for two tables. All of the values in table 1(State1) should apply to table two(State2), but any filters in table two(State2) should not affect table 1(State1).

I have attached a document. I tried to get this to work, but I have been unable to make changes to State2 once I implemented the trigger.

 

 

Labels (2)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Alternate States One state updates the other, but not the other way.

Doing this with triggers is a hard way to go. I sounds like you want State2 objects to honor selections from both States2 and State1.  The cleanest way to do that is use set expression in your State2 objects that includes both states:

=count({State1 * State2}Color)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

View solution in original post

1 Reply
MVP & Luminary
MVP & Luminary

Re: Alternate States One state updates the other, but not the other way.

Doing this with triggers is a hard way to go. I sounds like you want State2 objects to honor selections from both States2 and State1.  The cleanest way to do that is use set expression in your State2 objects that includes both states:

=count({State1 * State2}Color)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

View solution in original post