Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to force verify page or level

I have a excel report with sales data. I use the customer group dimension as a Page parameter so that each customer group gets their own sheet in the report.

Occationally, some Qlikview tables will not have data for every customer group (tables have separate filters). If this is the case, Qlikview will deselect the customer group and show data for every customer group in the "missing customer group" sheet.

This is VERY BAD since its difficult to identify if the actual customer group is the base of the data.

I need to use the "verify filter" option on the Page parameter to ensure that data exists.

Thanks in advance!

1 Reply
Frank_S
Support
Support

Your solution is correct when distributing user specific reports with a page or level filter. Using the verify filter option will prevent reports going to all users when data is empty for a specific user and for a specific dimension value.

To all community members: you may access verify filter in the 'Filters' screen of the NPrinting Designer as per below:

verify filter.PNG

Filter Definitions may be found at the link below:

Filter Syntax, Parameters, and Options for Importing Recipients – Customer Feedback for Vizubi

Other helpful links regarding Filtering:

How to Create Static and Dynamic Filters Based on Fields

How to Distribute User Specific QlikView Reports by E-mail

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!