1 Reply Latest reply: Oct 29, 2015 11:24 AM by Frank Savino RSS

    How to force verify page or level

    Carl-Fredrik Herö

      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!