topic Issue with variable Filter in Qlik NPrinting

Issue with variable Filter

dana — Fri, 08 Aug 2025 07:33:25 GMT

Hi People,

I have a report in a Qlik Sense app, which the following expression:

Sum({<Report_MonthNum = {$1}, Brand_SalesReport = {'$(vSalesReportBrand)'}, Year = {'$(vMaxYear)'}>} Monthly_$(vMeasureType))

vSalesReportBrand – to filter a certain brand with a button

vMeasureType – dynamically changes from Amount (the default) to Quantity

I’m trying to build an HTML report based on the app report.

I defined 2 variables filters :

vSalesReportBrand – works as expected.

vMeasureType - does not work. All the results are zero.

Here is the filter definition:

Any idea how to resolve it?

Thanks!

Re: Issue with variable Filter

Lech_Miszkiewicz — Fri, 08 Aug 2025 07:42:03 GMT

Hi @dana

:how do you change the variable? You say it dynamically changes.... based on what?

vMeasureType – dynamically changes from Amount (the default) to Quantity - on UI what is the trigger to toggle it? or in variable overview in Qlik Sense can you share how this variable is defined?

as a quick test - just expose this variable in your HTML NPrinting template and see if the filter is applied and lets take it from there

Re: Issue with variable Filter

dana — Fri, 08 Aug 2025 08:34:18 GMT

Dearest @Lech_Miszkiewicz ,

Exposing the variable indeed displayed the issue:
I had to attach to the filter value the currency as well, in order for it to work for Amount.

Thank you very much!