Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Sum up null values

Hi guys,

is it possible to sum up null values in a expression? For example: I want to have the sales of specific[CustomerGroup]  and the given null values: 

 

(sum({<

[CustomerGroup] = {'0001', '0003', '0004', NULL}

>}

Sales))

 

I tried it already with excluding but it didn't work either 😞

Thanks

 

Samuel

Labels (3)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Try like:

sum({1-<[CustomerGroup]={*}>+<[CustomerGroup] = {'0001', '0003', '0004'}>}Sales)

View solution in original post

3 Replies
Highlighted
MVP
MVP

may be this

=sum({<[CustomerGroup] = {'0001', '0003', '0004'}>+<[CustomerGroup]={"=len(trim([CustomerGroup]))=0"}>}Sales)
Highlighted
Contributor III
Contributor III

This is a good idea! Unfortunately it didn't work

Highlighted
MVP
MVP

Try like:

sum({1-<[CustomerGroup]={*}>+<[CustomerGroup] = {'0001', '0003', '0004'}>}Sales)

View solution in original post