topic Re: Include NULL values in selection in QlikView

Include NULL values in selection

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Include NULL values in selection

sunny_talwar — Fri, 05 Jan 2018 17:10:19 GMT

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

='=Sum(Amount) <= 60'

Re: Include NULL values in selection

mdmukramali — Fri, 05 Jan 2018 17:26:24 GMT

Hi,

As per stalwar1 Reply, you can adjust your expression,

Clear field:

Field_1

Select In field:

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