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

One filter to 2 differents informations in 2 differents tables

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

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 — Fri, 16 Feb 2018 22:14:09 GMT

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

shiveshsingh — Sat, 17 Feb 2018 03:18:25 GMT

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