Varibale formatting in NPrinting PowerPoint

[vanand3535]

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

[jampierre]

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

[vanand3535]

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