topic Hide/Exclude 0 from Total in Qlik NPrinting

Hide/Exclude 0 from Total

Fareeha123 — Tue, 19 Aug 2025 15:26:09 GMT

I am creating a table in pixel perfect. The measure column is showing Dual(sum and Count). Pixel perfect was not supporting dual function so i added sum formula field from Qlik and created count as formula in pixel perfect and inserted cell to show the count formula. When sum =0 it is not showing in total. when total count = 0 it is showing on Total group header, and we want to hide/exclude 0.

I tried formatting rule but it is giving error because my expression has set analysis

count({<OD_ReporingMonthEnd={'$(=$(vEndDate))'}>}OD_USD_Equivalent)

1. Can you please guide how to hide/exclude 0 from total?

attaching screenshot as example from the output.

2. when there is all is zero or null for a selection, how to show 'No Data' message instead of table ?

Re: Hide/Exclude 0 from Total

robert_mika — Wed, 20 Aug 2025 05:04:13 GMT

Create a new field in your Qlik data model:

If(OD_USD_Equivalent > 0 and OD_ReporingMonthEnd = $(vEndDate), 1, 0) as ValidCountFlag

Then in PixelPerfect:

Sum(ValidCountFlag)

Re: Hide/Exclude 0 from Total

Fareeha123 — Wed, 20 Aug 2025 15:10:07 GMT

I tried that it is still showing 0 in the total line

Re: Hide/Exclude 0 from Total

Lech_Miszkiewicz — Sat, 23 Aug 2025 02:09:16 GMT

Hi @Fareeha123

it is not clear exactly what you need. When it is 0 do you:

want to show total line but have nothing in it?
want to hide whole total line all together?

i am not understanding whether we need to focus on number formats which can have dedicated symbol for when it is 0 or if we need to make whole template dynamic (hide/show header) based on one value from total line?

Cheers

Re: Hide/Exclude 0 from Total

Fareeha123 — Mon, 25 Aug 2025 15:59:54 GMT

I wanted to hide the header when Sum and count in total is zero. I was able to achieve that by formatting rule. I created the rule using sum field. Sum(Field)<0 then visibility 'No' applied that rule to group header band. This way i was able to hide the headers when total was zero.

Re: Hide/Exclude 0 from Total

Ruggero_Piccoli — Tue, 02 Sep 2025 10:32:12 GMT

Hi,

Using formatting rules is the correct way to proceed in similar cases.

Best Regards,

Ruggero