Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
luiz_castro
New Contributor

One filter to 2 differents informations in 2 differents tables

Hello there,

I'm  starting with qlikview and have a problem that I can't solve.

As the document says I have two tables with the same information that comes from the same script table.

I Have a filter that cointains values that is the same as Year conclusion and Year creation.

For the exemple i picked 2018.

In the first table I want to filter Year conclusion, so it will show me  lines 2 and 3

In the second table I want to filter Year creation, so it will show me line 1.


Is it possible to do that? I tried with trigger but couldn't solve it.


I attachted my exemple and a exemple picture of it.


Thanks a lot

Exemple.JPG

Tags (2)
1 Solution

Accepted Solutions
Highlighted
ychaitanya
Contributor III

Re: One filter to 2 differents informations in 2 differents tables

Yes , It's possible.

1.We can create 2 Alternate States and

2.put Each Listbox object under each state.

3. Write set analysis expr to read the values from 2 selections and pass to the expr for creating conclusion and creation.

Hope this helps.

Thanks

CY

2 Replies
Highlighted
ychaitanya
Contributor III

Re: One filter to 2 differents informations in 2 differents tables

Yes , It's possible.

1.We can create 2 Alternate States and

2.put Each Listbox object under each state.

3. Write set analysis expr to read the values from 2 selections and pass to the expr for creating conclusion and creation.

Hope this helps.

Thanks

CY

shiveshsingh
Honored Contributor

Re: One filter to 2 differents informations in 2 differents tables

Please do it with help of alternate states, assign two diffrent alternate states to you listboxes and use them in expressions