Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
daudballing
Partner - Contributor III
Partner - Contributor III

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

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. 

Labels (2)
1 Solution

Accepted Solutions
Lech_Miszkiewicz

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

cheers

Lech

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

4 Replies
Lech_Miszkiewicz

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

cheers

Lech

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.
daudballing
Partner - Contributor III
Partner - Contributor III
Author

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...

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.
daudballing
Partner - Contributor III
Partner - Contributor III
Author

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