Create a Button which can include Null value

Mon, 11 Jul 2016 17:40:48 GMT

Hi all,

I did some search online but cannot come to a way to include Null Value in the selection.

The thing I need to do: I am going to create a button which make a variable A exclude a particular value a1. However A has some NULL value in the record, I need to keep these records.

Could anyone help me out on this problem?

Thank you

Re: Create a Button which can include Null value

swuehl — Mon, 11 Jul 2016 20:48:59 GMT

Have a look at

Excluding values in Set Analysis

You would need to identify a key field (or create a new field in the script), then the set expression might look like

=Sum({1<KeyField = e({$<A = {a1}>}) >}Value)

If you need to create a button Selection - Select in field action, then use the KeyField as field to select in and something like

='=Sum({1<KeyField = e({$<A = {a1}>}) >} 1)'

as search string

topic Create a Button which can include Null value in QlikView

Create a Button which can include Null value

Re: Create a Button which can include Null value