Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create a Button which can include Null value

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

View solution in original post

1 Reply
swuehl
MVP
MVP

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