Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Create a Button which can include Null value

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

1 Reply
MVP
MVP

Re: Create a Button which can include Null value

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

Community Browser