Include NULL values in selection

[Anonymous]

Hi,

I have two fields (one is a set of keys, "Field_1" and the other one is a number field, "Amount"). I created a slider so that the user can select only rows that have an Amount less than or equal to a user-specified value. However if there are any rows that happen to have a NULL Amount, such rows should also be included in the resulting selection.

Please see attached sample qvw file.

[sunny_talwar · Accepted solution]

Trigger on Field_1, rather than Amount itself using this search string

='=Sum(Amount) <= 60'

[mdmukramali]

Hi,

As per stalwar1 Reply, you can adjust your expression,

Clear field:

Field_1

Select In field:

='=Sum(Amount) <=$(vMaxValue)'