Text color in NPrinting power point

[poooja]

Hi Qlikies,

Is there a way we can do conditional color for text in the power point slide. Actually i am bringing qlik sense app KPI object expression as formula in Nprinting. And needs to show the color like >= 100 is green, < 100 is blue.

Thanks!

Pooja

[Lech_Miszkiewicz · Accepted solution]

Conditional formatting in PowerPoint does not exist and this is not really NPrinting question as it fits more in MsOffice community question...

but...

If you are talking just about KPI and want to do this directly in NPrinting the workaround would be:

• create PPT template
• for 1 KPI create 2 formulas with thresholds you need; for example:
  • If(Sum(Expression1)>100,' ',Sum(Expression1)) - this would be formula calculating and returning value when greater than 100
  • If(Sum(Expression1)<=100,' ',Sum(Expression1)) - this would be formula calculating and returning value when lesser than 100
• in PPT template you bring first formula and set it up and hard-code colour of it to red and you also put in the same position second formula and hardcode it to Green

Effectively you place both formula placeholders in the same spot in your template (one on top of another). If the formula does not meet "if condition" it will return nothing (be transparent) and for condition met it will return value in already hard-coded colour.

I understand this is lot of work, but for PPT that is the best i could come up with (except using images)

Check images for reference:

create formulas:

drag formulas to the template

put formulas in exactly the same spot (one on top of another)

[poooja]

Hi Lech,

Awesome!! Thank you for your suggestion. Sounds like a way.

Kudos to you.:)

Thanks!
Pooja 

[Spiller]

Is this the only way to make it work? I want to include a color indicator in a resulting powerpoint table, but then the indicators are not aligned properly anymore when the content of the other fields is longer than one row.

Tried to put the  indicators after each other, but then the coloring of only the first is applied.  

[Ruggero_Piccoli]

Hi,

Please start a new conversation for a new issue with all the informations (like screenshots, steps, etc) useful to reproduce the issue. 

Commenting an old conversation marked as solved could not be notes and receive no answers.

Thanks.

Best Regards,

Ruggero