topic Problem with selections in Qlik Automate

Problem with selections

alexdelagarza — Tue, 10 Sep 2024 15:19:33 GMT

Hello everyone,
I have a group of scenarios that correspond to different sections of a highway as can be seen in the following table:

I have an expression that should return the records that are at the intersection of scenarios 204 and 208, but it returns records from other scenarios as well, such as 104, 107, 108, etc., as can be seen in the following table:

This is the expression:

=count( {$<ID_CARD= P({<Escenario2={'208'}>})*P({<Escenario2={'204'}>})>} ID_CARD )

If I use the filters and select only the scenarios I want, I get the result I expect:

But, I need you to give it to me without using the filters.

I hope you can help me.
Thank you very much

Re: Problem with selections

rubenmarin — Sun, 15 Sep 2024 18:03:26 GMT

Hi, that expression filters only the ID_CARd field, so if a value of that field is on another scenarios they will show.

You can add the fitler for the wanted scenarios on the same set analysis:

=count( {$<ID_CARD= P({<Escenario2={'208'}>})*P({<Escenario2={'204'}>}),Escenario2={'208','204'}>} ID_CARD )

Re: Problem with selections

Vegar — Mon, 16 Sep 2024 04:43:16 GMT

Consider if P(...) is the right syntax for your need. Maybe you should skip using them and replace them with a more direct modifier.

=count( {$<Escenario2={'208','204'}>} ID_CARD )

Re: Problem with selections

alexdelagarza — Tue, 24 Sep 2024 23:10:08 GMT

Thanks it worked, sorry for the late answer.