Qlik Excel reporting Remove or Do Not show the NULL values / rows / Levels

[prads_uk_2025]

Hi,
I am working on Qlik Saas Excel Add-Ins reporting.
I have 2 Levels:
Asset Type: Long Book
Category: Equity, NA, PIK Note
as can see from the screenshot below:
Since, Equity and NA have no values #REF is coming whereas, it should not be in PDF at all.
How can I omit it? 

[Lech_Miszkiewicz]

Hi @prads_uk_2025 

To achieve certain things you need to prepare your qlik app in certain ways. I explained what you need to do and that is to build tables with certain dimensionality as that drives behaviour of your report.

if you dont do that then there is no point me trying to explain how things work. Those steps were compulsory and there is no point trying different things like for example using tables with 5 dimensions for level which requires one dimension.

This is very basic report and building it must follow simple approach of

• building UI table with ONE DIMENSION AND MEASURES for most outer level
• building UI second table with TWO DIMENSIONS AND MEASURES for inner level
• using third table with all dimension as source of rows with data for your report

thats it. It is as simple as that and you just have to do it because this is the method of doing things in this tool.

I don't care about PBI and how it works. It is a different tool, it works different. Qlik works in different way and requires approach i have provided you to achieve outcome you want using it.

Simple as that. Sorry but that is the reality. 

cheers

[prads_uk_2025 · Accepted solution]

Achieved it using IFERROR(SUM(Cellvalues),0)