Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Partner
Partner

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

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.

Labels (4)
1 Reply
vikky
Contributor II

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

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...