Discussion Board for collaboration on Qlik NPrinting.
I have created two variables in Qlik Sense which I'm using in NPrinting PowerPoint report in rich text box.
1st variable expression :-
2nd variable expression:-
output is coming for a selected filter in NPrinting PowerPoint report is:-
If both Min & Max value is 0-0 then it should display "<1%"
but if both variable has some min & max value then it should display respective data
So, How can I format the variable like this?
Please help me out regarding this.
Thanks in Advance.
I'm not sure I well understood the problem but I'll try to give you a solution .
Have you tried to create a new variable in QlikSense (vVar3 for instance) like this!?
if($(vVar1) = 0 and $(vVar2) = 0, '<1%', $(vVar1) & '-' & $(vVar2) & '%')
You can use vVar3 in NPrinting
Hope it helps
I would not use variable (and my reasoning is behind how $ sign can evaluate), but instead i would use above mentioned IF statement in NPrinitng formula
Actually, Yesterday I have to finish it by anyhow so I have created 2 variables using IF_ELSE condition and I have placed both variables close to each other and sorted out that problem. I will try with your suggestion also.
same for max:-
In between both varibale I placed a '-' symbol
if both min and max is 0 then output is:- <1-<1
if there is some value for min or max then output is:- min(sales)-max(sales)
Correct - If Else statement can also work in variable, there are some scenarios where it can be little bit more tricky since you have used variable in variable etc...
but at the end it all can also work just like you did.