topic Re: NPrinting Excel Using Levels for Subtotals - On-Demand Filter not applying to levels in Qlik NPrinting

NPrinting Excel Using Levels for Subtotals - On-Demand Filter not applying to levels

craigbrett — Thu, 09 Feb 2023 11:34:43 GMT

Hi All

I have built an excel report that is using paging to create a new sheet for each "Customer" and levels to create a table with subtotals for each "level".

When I run the report from NPrinting (in the template editor) it displays perfectly as expected.

When I run the report using on demand it creates all the levels for each table regardless of the paging filter applied.

I have searched for an answer but have found nothing. It seems the selected on demand App filters have no effect on the leveling applied to the excel report.

Thanks

Re: NPrinting Excel Using Levels for Subtotals - On-Demand Filter not applying to levels

Ruggero_Piccoli — Thu, 09 Feb 2023 13:58:30 GMT

Hi,

Be sure you are applying filters to the same app used as the source of the report.

For debugging purposes, you can add a Formula in the template with =GetCurrentSelections() so you will see the list of applied filters.

Best Regards,

Ruggero

Re: NPrinting Excel Using Levels for Subtotals - On-Demand Filter not applying to levels

craigbrett — Thu, 09 Feb 2023 14:28:37 GMT

Thanks Ruggero

I figured out the issue, I was using set analysis on the table measure to filter the data in the table. Once I removed the set analysis and used actual selections in the App the results come out as expected.