topic Re: Use variable value in Nprinting in Qlik NPrinting

Use variable value in Nprinting

curiousfellow — Fri, 29 Apr 2022 11:14:38 GMT

In my Qlik document I have several button that set values to two variables.

based on those two values an expression is selected to show values in a bar chart.

for example If var1= Y and var2 = Z then sum(sales),

if var1= x and var2 = B then sum(costs) etc. etc

I want to use this bar chart in Nprinting. Is it possible to set static values in Nprinting for these two variables ? In that case thecorrect expression is used for the values I want to display in the bar chart.

I know I can set a value to a variable that is used for a dimension but I could not find if this can be used for expression too.

Re: Use variable value in Nprinting

Ruggero_Piccoli — Fri, 29 Apr 2022 12:23:58 GMT

Hi,

In Qlik NPrinting you can use Filters to set the value of a variable. It is documented in https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.htm#anchor-10

Then you can apply the filter as a normal filter to reports, tasks, users or objects.

Best Regards,

Ruggero

Re: Use variable value in Nprinting

Digvijay_Singh — Fri, 29 Apr 2022 12:26:19 GMT

I recently used Variable in the nprinting filter and used that filter as a task filter, it worked perfectly for me. I wanted to show Quarters or months in the bar chart so I created two variable filters in nprinting with different values, and used them in two separate tasks so that same chart can show quarters or months in two different tasks. Not sure if you can do somewhat similar.

Re: Use variable value in Nprinting

curiousfellow — Fri, 29 Apr 2022 12:41:21 GMT

As far as I can see in the link, I need to enter a dimension.

So it must be possible to set a value to a variable even if that variable is used in an expression?

That was what I tried before I started this topic, but I did not get any result. My variable is a textstring, and I tried several options , with or without apostrophes , with or without the '=' sign and with or without the evaluate box checked.

I used the filter in the report settings and in another attempt in the template. But still no results.

Re: Use variable value in Nprinting

Ruggero_Piccoli — Fri, 29 Apr 2022 13:36:45 GMT

Hi,

I created a filter to set the value of the Variable named Dimension01 to Country. It is a text variable:

it is used to change a QlikView chart:

On the same filter I set the value of the vCurentYear variable by calculating it:

I added the filter to an Excel report template

the preview is as expected

If I change the value of the variable Dimension01 to City

the preview changes

I hope this helps.

Best Regards,

Ruggero

Re: Use variable value in Nprinting

curiousfellow — Mon, 02 May 2022 08:24:27 GMT

vCurrentyear is used in the expression or is used to set a dimension value ?

Re: Use variable value in Nprinting

Ruggero_Piccoli — Mon, 02 May 2022 10:18:58 GMT

Hi,

In my example vCurrentYear is used just to demonstrate how to set the value of a variable by placing it in the template.

The variable called Dimension01 is used in the QlikView chart to set the first column.

Best Regards,

Ruggero