Dimensions without values

[QlikCommSa]

Hello,

I created a NPrinting PDF Pixel Perfect report with the Template Editor.

In my QlikSense app I have 2 tables, one with the sales and one with the orders of different locations. In my NPrinting Report I want to have these two tables, one site for each location. So far it works perfectly. But locations without any sales and orders are also shown in the Report with empty tables. 

In the template editor I first have Level "location" and then a level for each table (on equal level, right under the location). 

I unchecked "include null values" for the location in my app for both tables.

Is there any workaround how to get the empty sites (almost, apart from the empty tables) removed?

Please let me know if you need any further information!

Thanks in advance! 🙂

[Ruggero_Piccoli · Accepted solution]

Hi,

That is because you created the first level Location by using the Location field. This will produce a level for each distinct value of the Location field.

Instead create a straight table with the location field and the sum of related sales with rows only for locations that have sales. Than refresh the connection cache, close and reopen the Qlik NPrinting Designer and use that new straight table to create the first level.

Best Regards,

Ruggero

[QlikCommSa]

Hi,

thanks! This works, but is really not user friendly. Should be a common case to only show the dimensions with values?! I would have expected that there is an option to tell the Template Editor.

BR!

[Ruggero_Piccoli]

Hi,

The one I described is a standard way to filter the values used in a level. The are no reasons to add an option because you can do it in the described way and also because you can filter the values on the straight table based on different criterias. This way is also supported starting from very old versions of Qlik NPrinting (older than 16).

Best Regards,

Ruggero