topic Re: Undesired selection in filtering field in QlikView

Undesired selection in filtering field

NickP_DF — Fri, 08 Sep 2023 09:41:50 GMT

Hello guys,

I need to get some records from a secondary table by selecting them on the selection of another field in the primary one; I used the "Selection in Field" trigger on selecting and changing the value of the primary table field

It works properly when there are records which satisfy the condition (there is at least one record of the secondary table with DataMovMag between the minimum and the maximum of DataVandita), but it selects all records of the secondary table if not (instead of selecting no records).

Am I doing a wrong set of the search condition or is this behavior correct in Qw?

Thank you for the help.

Nick

Re: Undesired selection in filtering field

marcus_sommer — Mon, 11 Sep 2023 12:08:20 GMT

If none condition is fulfilled it results probably in an invalide search-string. To ensure that your search-string is always valide you will need to embed it within any check-routine, like:

if(MyCondition = true(), MySearchString, false()) // or maybe null() instead of false()

Beside of this I suggest to re-think the entire approach in regard to:

Let the User Select - Qlik Community - 1463978

Re: Undesired selection in filtering field

NickP_DF — Wed, 13 Sep 2023 09:12:16 GMT

Thank you, Marcus, I'll follow your suggestion to review the entire BI.