Issue with variable Filter

[dana]

Hi People,

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!

[Lech_Miszkiewicz · Accepted solution]

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

[dana]

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!