Undesired selection in filtering field

[NickP_DF]

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

[marcus_sommer]

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

[NickP_DF]

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