Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vanand3535
Creator III
Creator 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

4 Replies
jampierre
Partner
Partner

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

Lech_Miszkiewicz

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.
vanand3535
Creator III
Creator III
Author

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)

Lech_Miszkiewicz

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.