hoe to eliminate empty table when using Levels

[ilanbaruch]

Hi All

in my excel report i'm using Country Field as a Level to break down into separated sheet for each Country.

some of the countries does not contain any data in the specific table and they not appear in the app, but in the report all countries values appear in the report with blank sheet.

any idea how to eliminate the empty sheets ?

advanced thanks

[Frank_S]

Hello @ilanbaruch 

I worked on this yesterday but I still get a blank sheet I use the 'page' feature and an empty 'Reba Mac' data row with levels as output.

Please post your requirement here as a feature request at your convenience.

Ideas | Qlik Community

As a very less than graceful, 'unsophisticated' 🙂 workaround you could produce your report to find out which users/countries have blank data and then create/define a filter for the remaining users or in your case 'Countries', that do have actual data. Add your filter (which only includes countries that are known to have data) to the task (example below)

I even tried an 'if' condition to show nothing / empty value as a evaluated filter but it also did not prevent all the dimension/field values from appearing as a sheet. It just shows up in the sheet as an empty cell value.

Others here may have more graceful workarounds.

Kind regards...