NULLs in a table (how to hide them, but count them in the totals)

[morenoju]

Hi all,

I have a table with a list of locations and a count of events that took place in these locations. The table is ordered by that count.

The issue I'm having is that many events have a NULL location and I don't want to see that in the top of my table. 

I went and unchecked "Include null values" and the nulls are gone. The problem is that I want those events counted in the "Totals" row.

Any idea on how to hide them but still counting them?

Thanks.

[vikramv]

Try to replace null() with a any symbol like underscore.
Or you can use Set Null interpret function to make your work ease.Refer to below link.
https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/null-value...