Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
vCurrentyear is used in the expression or is used to set a dimension value ?
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-fi...
Then you can apply the filter as a normal filter to reports, tasks, users or objects.
Best Regards,
Ruggero
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.
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.
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
vCurrentyear is used in the expression or is used to set a dimension value ?
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