nPrinting/Qlik Sense: Color native PowerPoint table cell text/content by value, expression, or variable value, etc.

[daudballing]

Hi all,

We are building a PowerPoint report showing performance metrics for different business areas, for the current month, shown in percentage numbers.

Now, we need to display the information in a table with some traffic light indicators (green, yellow, red) based on performance thresholds. (e.g. one single table column with rows for each business area performance)

Is there a way to color the content of the table cells based on variable values, data injected through Qlik Sense data tables, or any other work around to achieve this?

Using the default Qlik Sense style format and carry this over to PowerPoint is not accepted (the 'Keep format' option). Only native PowerPoint tables/charts allowed, for company branding and design purposes.

Curious to hear if anyone has gotten this to work. 

[Lech_Miszkiewicz · Accepted solution]

simple answer - no ,that is not possible with native PPT table, it is power point limitation though.

cheers

Lech

[daudballing]

Thank you, Lech. This is what I feared as well.

Do you know if it is possible to color some text or text symbols (unicode bullet dot) instead still within PowerPoint based on the same approach? We would then maybe be able to align the unicode text so that it looks like it is cell values is in a table cell. Any other work around ideas is very much appreciated.

Thanks again - 

[Lech_Miszkiewicz]

This is the only solution I came up with some time ago:

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Text-color-in-NPrinting-power-point/td-p/16...

[daudballing]

Sorry, Considine28, but is your reply related to this post?