Setting variable in Nprinting report

[danette]

Hello!

I have a table in Qlik Sense where some measures and dimensions are computed based on a variable.

For example, I use a measure like this:
Aggr(Sum(UnitSales * UnitPrice), Customer $(v_aggr2))

When I don't need a second aggregation level, v_aggr2 is empty. When I need the second aggregation level, v_aggr2 might be equal to ,country or ,city.

This works perfectly in Qlik Sense, where I can switch the value of v_aggr2 (e.g., to ,country or ,city) using a button.

However, I now want to create a report in NPrinting, setting the variable to ,country.

When I try to set the variable in the NPrinting filter, I get an error. I’ve tried several approaches: enabling the "Evaluate" option, using quotation marks, not using quotation marks... but nothing works.

The error I receive is:
Failed generation of report xxxxxx user xxxxx. ERROR: Cannot resolve content for node v_aggr (object: V\v_aggr2) due to invalid selections.

What can I do to fix this issue?

[Lech_Miszkiewicz]

Hi @danette 

i will need to test this tomorrow. 
i am assuming the problem is with the “,” in variable. 

will get back to you tomorrow with my results. 
cheers

[Lech_Miszkiewicz · Accepted solution]

Hi @danette 

The issue was actually different than I thought. 

In my case I hade to set "empty variable" to as " " (space) character and then filter of ",WeekDay" worked ok. It turend out that for some reason NPrinting does not like if variable had no defined value. By entering blank space as a default it then further work ok. 

Variable in Qlik Sense (instead of empty string I put space in there)

Showing toggle between aggr measure (same as yours aggr by single or multiple dimensions). In this case having a space does not break a single dimension aggr.

NPrinting filter - straight text with variable value i want to set

Template

Result

You may want to open support ticket if you wish to see why empty string is not working but you will need to make sure you can provide Qlik with all the steps and sample apps to replicate the issue. 

hope this helps.

cheers

[danette]

Hi @Lech_Miszkiewicz !

It worked like a charm!

Inside the dashboard, I changed the default variable value, adding an empty space. After that, I was able to set the appropriate variable value in Nprinting, just like you explained.

Thank you very much