Report Error When No Data in Excel Tab

[bbergstrom]

We have an Excel NPrinting report that has 4 tabs:

US

Canada

Mexico

Definitions

I'm trying to set it up so that the tab for a country appears only if there is data but the last tab for Definitions always appears.  I set up a count field (equals 1 for each row) in my loadscript and applied a filter on the report where the Filter name = 1.  This works as long as there is some data but if there is no data at all the report errors out and no tabs are displayed.  Is there a way to have a filter only affect certain tabs or a way to force a tab to always appear?

[Lech_Miszkiewicz]

How about:

• using page for country to page over Countries you need and apply "Advanced search" filter on country field to ensure which countries have data https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/
• If definition tab needs to ignore country selection you may need to create dedicated objects for it in your Qlik Application with ...{<Country=>}...set analysis in it

If definition tab does is not affected by Country selection then you can just build normally. 

Your question is really related to your Qlik Data model and what objects (including:dimesnions, measures, types) you are using in each of the tabs... It is hard to help without knowing how they are modelled in Qlik script.

[Lech_Miszkiewicz]

btw - if you need a tab to always appear you can create dummy record in your model with the flag 1 just by concatenating it to your fact table