One filter to 2 differents informations in 2 differents tables

[Anonymous]

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

[ychaitanya · Accepted solution]

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]

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