Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I defined a simple variable (vCurrentYear) in a Qlik sense app, which I connected to my NPrinting report.
(Value of this variable is "2024")
I successfully added this within the Nprinting Designer.
When I want to create a chart with this, no matter which notation I try, I always get the variable definition itself, but not the value as output.
I tried:
'=$(vCurrentYear) (Excel doesn't accept it without ')
'=(vCurrentYear)
'(vCurrentYear)
'vCurrentYear
What do I do wrong? In the Qlik Sense Table, when I use =vCurrentYear as expression for the label, it shows up as 2024.
Any more information needed? Please let me know!
Hi @Moritz
in your last comment there are few words which change everything!!! You said: "Here's how the excel spreadsheet look like, which serves for the powerpoint chart:". That is a perfect example of how important is to provide detailed explanation of the problem 🙂
Workaround - I know it is not great but:
cheers
I've tested the following and it works fine.
If the syntax is not right in Qlik Sense, it will not work in NPrinting as a variable filter.
Also if you use =(vCurrentYear) as a table column dimension, you'll need to create another another identical variable in Qlik Sense and use the duplicate as your NPrinting Variable.
For details see:
Kind regards...
Hi @Moritz
Franks link sayis it all - if you refer to variable in Qlik as a lable then situation you describe is that variable will not expand in NPrinting as documented.
Workarounds:
cheers
Hi @Frank_S and @Lech_Miszkiewicz
thanks a lot for your responses already! Not sure if I follow completly, but it seems this isn't working from out of the box right?
So, I meanwhile have the variables in line in NPrinting and Qlik. here's the variable definition in Qlik sense (hard-coded without FX:)
Here's how i set it up in the Nprinting template Editor (tried with variable as well as with formula.)
The formular is configured as such:
Here's how the excel spreadsheet look like, which serves for the powerpoint chart:
and here's the powerpoint result:
Any help highly appreciated!!!
Hi @Moritz
in your last comment there are few words which change everything!!! You said: "Here's how the excel spreadsheet look like, which serves for the powerpoint chart:". That is a perfect example of how important is to provide detailed explanation of the problem 🙂
Workaround - I know it is not great but:
cheers
Thanks so much @Lech_Miszkiewicz and @Frank_S this worked fine with both of your help!
The workaround, separately including the legend as formula is brilliant!
Standing ovation for your elegant solution @Lech_Miszkiewicz
Happy to provide feedback @Moritz
Thanks @Frank_S - as you know it is always art of workarounds 😁