Query about Input Boxes Objects Filtering

AY3366 — Fri, 05 Apr 2024 03:19:41 GMT

Hello community,

In my dashboard, I created total four input boxes for users to input their desired values and the following table will only display values of 'A amount' and 'B amount' within the range of min input boxes and max input boxes. First what I did was to input '10000' in Min input box for 'A Amount' ,and then input '20000' in Max input box for 'A Amount'. And one record left because it met the condition (Pic1). However, when I also input '10000' in Min input box for 'B Amount' the 'B Amount' value for the record became null (Pic2). My assumption was that the original value of 'B Amount' for this record was less than '10000' so that Qlik changed it to null value, but what I tried to achieve here was that if the record did not meet the conditions based on what I input in the input boxes it should be excluded instead of changing the record's value to null, thanks!

Re: Query about Input Boxes Objects Filtering

marcus_sommer — Fri, 05 Apr 2024 12:04:02 GMT

It might be related to the way the variables are called - and NOTHING in the input-box may lead to NULL by calling the variable with a $-sign expansion. Therefore try instead of: $(vVar) a call of vVar.

Beside this you may consider to enforce always valide values - maybe by restricting the input-values in any way or implementing any kind error-handling.

topic Query about Input Boxes Objects Filtering in App Development

Query about Input Boxes Objects Filtering

Re: Query about Input Boxes Objects Filtering