topic Re: Varibale formatting in NPrinting PowerPoint in Qlik NPrinting

Varibale formatting in NPrinting PowerPoint

vanand3535 — Mon, 08 Oct 2018 10:13:54 GMT

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

Re: Varibale formatting in NPrinting PowerPoint

jampierre — Mon, 08 Oct 2018 15:04:39 GMT

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

Re: Varibale formatting in NPrinting PowerPoint

Lech_Miszkiewicz — Mon, 08 Oct 2018 22:53:17 GMT

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

Re: Varibale formatting in NPrinting PowerPoint

vanand3535 — Tue, 09 Oct 2018 10:30:18 GMT

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)

Re: Varibale formatting in NPrinting PowerPoint

Lech_Miszkiewicz — Tue, 09 Oct 2018 20:43:38 GMT

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