Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
vanand3535
Contributor III

Varibale formatting in NPrinting PowerPoint

Hi all,

I have created two variables in Qlik Sense which I'm using  in NPrinting PowerPoint report in rich text box.

1st variable expression :-

Min(Sales)

2nd variable expression:-

Max(Sales)

output is coming for a selected filter in NPrinting PowerPoint report is:-

Expected output:-

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.

Vivek Anand

Tags (1)
4 Replies
Highlighted
Partner
Partner

Re: Varibale formatting in NPrinting PowerPoint

Hi Vivek,

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

Regards

JP

Highlighted

Re: Varibale formatting in NPrinting PowerPoint

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

cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Highlighted
vanand3535
Contributor III

Re: Varibale formatting in NPrinting PowerPoint

Hi Lench,

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.

Ex- if(min(sales)='0','<1',min(Sales))---varibale1

same for max:-

if(max(sales)='0','<1',max(Sales))-----varibale2

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)

Highlighted

Re: Varibale formatting in NPrinting PowerPoint

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.

cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.