topic Setting variable in Nprinting report in Qlik NPrinting

Setting variable in Nprinting report

danette — Thu, 05 Dec 2024 11:07:57 GMT

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?

Re: Setting variable in Nprinting report

Lech_Miszkiewicz — Thu, 05 Dec 2024 12:56:18 GMT

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

Re: Setting variable in Nprinting report

Lech_Miszkiewicz — Fri, 06 Dec 2024 04:09:37 GMT

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

Re: Setting variable in Nprinting report

danette — Fri, 06 Dec 2024 10:12:05 GMT

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