All values in table (including nulls and zeros)

[qlikeers]

Hi!

I wonder (I have something like in the attachment) - how to display all customers in a three-column table (regardless of the sum of sales)?

CustID	Name	Sum(Sales)
C100	...	1000
C105	...	null
C110	...	0
....	...	...

[niclaz79]

Hi,

You have to unclick 'Suppress when value is null' on the Dimensions-tab and then also unclick 'Suppress zero values' in presentation.

[qlikeers]

I have only:

1) "Include null values" - in dimmension (selected)

2) "Include zero values" - in Add-ons, Data handling (selected)

Didn't work.

[suhaskharat]

Remove suppress zero value from presentation tab too!!

[rubenmarin · Accepted solution]

Hi Kuba, one option is adding "+Sum({1} 0)" to the expression, customers without data will show 0

To set the string 'null' you can try wih:

If(Count(Sales)=0, 'null', Sum(Sales))

[sibin_jacob]

If you want to show all Names without considering any selection, please use the below expression for sales

Sum({1}Sales)

[qlikeers]

Thanks rubenmarin!

It works!