Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
poooja
Creator
Creator
‎2019-10-01 03:05 PM

Text color in NPrinting power point

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
Labels (1)
Labels
1,403 Views
0 Likes
1 Solution

Accepted Solutions
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2019-10-01 09:54 PM

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:

1.PNG

 

drag formulas to the template

2.PNG

 

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

3.PNG

 

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.

View solution in original post

1,385 Views
0 Likes
4 Replies
Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2019-10-01 09:54 PM

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:

1.PNG

 

drag formulas to the template

2.PNG

 

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

3.PNG

 

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.
1,386 Views
0 Likes
poooja
Creator
Creator
‎2019-10-01 11:18 PM
Author

In response to Lech_Miszkiewicz

Hi Lech,

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

Kudos to you.:)

Thanks!
Pooja 

1,376 Views
0 Likes
Spiller
Contributor III
Contributor III
‎2021-01-18 03:16 AM

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.  

1,121 Views
0 Likes
Ruggero_Piccoli
Support
Support
‎2021-01-18 05:44 AM

In response to Spiller

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



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
1,103 Views
0 Likes