We have NPrinting PDF and Excel templates that have levels/pages based on the client country. At the moment if a client has a branch in a country but no data the sheets or pages are still showing. Is there a way to suppress a page or sheet if there is no data?
For instance, Client A has branches in the US, Canada and Mexico but has no sales data for Mexico. I want to hide Mexico but still display the other two countries.
This is with Qlik Sense April 2018 and NPrinting November 2018.
you need to create your levels and pages based on straight tables (not only fields) with dimension and measure which will decide if there is a data for a combination of your dimension fields. Make sure to suppres 0 values in those tables to remove records where there is no sales, hence loops will only go through dimension values shown in table.
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Thanks! That worked great for a Word template. For the Excel template when I Add Page to Current Sheet I am not seeing the new object I created. I can see it in the levels but I was told to use the Page to create new sheets based on the country.