topic NPRINTING: Power Point Table Cell Color in Qlik NPrinting

NPRINTING: Power Point Table Cell Color

steve1982 — Tue, 16 Apr 2019 09:06:15 GMT

Hi,

I am create a PPT on NPRINITNG, which the link to Qlik Sense. How to show a field on PPT on table with color code with criteria. The color is set on Qlik Sense, but it not able to show on NPRINTING PPT.

Thanks

Steve

Re: NPRINTING: Power Point Table Cell Color

Lech_Miszkiewicz — Thu, 18 Apr 2019 02:11:45 GMT

Well,

I don't really know how you are formatting your objects in Qlik Sense also you are not telling us how you are bringing it to NPrinting. You also did not give us any information about versions of software you are using, nor providing screenshots of how you have built your template.

All what I can say is that it can be done using Qlik Sense and NPrinting. Below are the steps i did...

I brought in to PPT Qlik Sense table with formatting. If you want to carry across Qlik Sense conditional formatting you need to have " Keep Source Formats" checked. (see picture)

This obviously means that you cannot use PPT formatting as you can only choose either Qlik or PPT formatting - not both at the same time! It is obvious-right?

When you execute it carries across formatting as in Qlik Sense (see screenshots)

Source in Qlik Sense

Results in PPT

If you had something else in mind - then elaborate more and provide detailed description with samples and screenshots.

cheers

Lech

Re: NPRINTING: Power Point Table Cell Color

charu16aug — Thu, 08 Jun 2023 10:26:26 GMT

Please can you tell me, how the colors you have added in Qliksense reflecting same in Nprinting as well?

Re: NPRINTING: Power Point Table Cell Color

Lech_Miszkiewicz — Thu, 08 Jun 2023 10:29:27 GMT

I already told you - Use Keep source format setting "checked". I have even highlighted that in my screenshots.

Also - note I use Qlik Sense straight table for this to work

Re: NPRINTING: Power Point Table Cell Color

charu16aug — Thu, 08 Jun 2023 10:32:17 GMT

hey, actually i'm also doing the same keeping the source format checked and already added the colors to cells based on background expression in Qliksense,but this is not working for me

Re: NPRINTING: Power Point Table Cell Color

Lech_Miszkiewicz — Thu, 08 Jun 2023 10:47:53 GMT

Ok,

are you using straight table (not pivot)?
are you using native object (not extension)?
are you adding columns individually in NPrinting - just like I do?
did you regenerate metadata after you populated your conditional format formulas and updated table nodes in NPrinting designer after doing so?
do you have keep source format checked on all columns? This setting is separate on table tag vs column tag. Make sure you check both.
what are the versions of Qlik Sense and NPrinting you are using. Make sure you use supported configuration as documented in https://help.qlik.com

Re: NPRINTING: Power Point Table Cell Color

Lech_Miszkiewicz — Thu, 08 Jun 2023 10:48:55 GMT

one more very important question: What are the expressions you use for colours?

Re: NPRINTING: Power Point Table Cell Color

Charu_1628 — Thu, 08 Jun 2023 10:55:54 GMT

1.yes,Staright table
2.No extensions
3.I'm creating a table in PPt then adding each column to it
4.Yes
5.Yes
6.Qliksense feb2023,nprinting-May 2022
expression used at Qliksense-
=if(YEAR = '2023',
if ((sum({<CONSOLIDATED_LOB= {'Auto'}, YEAR = {'2023'}>}Quote)) > (sum({<CONSOLIDATED_LOB= {'Auto'}, YEAR = {'2022'}>}Inquiry)),
LightRed(), LightGreen()),
white())

Re: NPRINTING: Power Point Table Cell Color

Charu_1628 — Thu, 08 Jun 2023 10:56:38 GMT

Re: NPRINTING: Power Point Table Cell Color

Lech_Miszkiewicz — Thu, 08 Jun 2023 11:08:07 GMT

Strange...

What happens when you bring this table as image? Do you get colours reflected when it is brought in as image? Maybe create test slide for it and check.
I normally drag & drop fields to powerpoint like shown below - can you try doing this as well:

I dont have anything else to add other then checking that app connection actually points to the app which has your coloured table. Also if you used Master Measures references in your colour expression that possibly could cause some troubles as there was a bug which prevented master measures in expressions from working properly in NPrinting.

If nothing works - open support ticket.

Re: NPRINTING: Power Point Table Cell Color

rameshwary — Tue, 27 Feb 2024 08:26:44 GMT

@Lech_Miszkiewicz thanks for sharing. Using same method to get background color of column but unable to do layout setting for all columns it is going beyond the page.

Can you please help for fit all columns in 1 page design layout. Please find attached :

It is going beyond slide .

Re: NPRINTING: Power Point Table Cell Color

Lech_Miszkiewicz — Wed, 28 Feb 2024 07:38:43 GMT

Sorry - I don't see your template. I only see table with Black background, some headers and some colours on your screenshot, but I dont know how you have built it in Qlik Sense nor in NPrinting so I dont know what you do wrong.

I tested it on my sample app and it works for me. I dragged and dropped object on the sheet and ensured that I have set the required width on the template in PPT.

Re: NPRINTING: Power Point Table Cell Color

rameshwary — Wed, 28 Feb 2024 09:56:14 GMT

Hi @Lech_Miszkiewicz ,

I have developed same way which you shared above. Feature is working fine but issue facing with alignment or layout is going beyond slide. Attached SS for the same . I have highlighted data with Black so it is showing black color.

Nprinting Design Template :

Output looks like going beyond slide :

Re: NPRINTING: Power Point Table Cell Color

Lech_Miszkiewicz — Wed, 28 Feb 2024 11:16:38 GMT

Hi @rameshwary

When you say it is going beyond the slide - do you mean it is wider than slide or data (rows height) is expanding so it expands below the bottom of the slide. Sorry this is very hard to understand from those screenshots where there is no reference to the whole slide/power point window etc.. we cannot see on those slides where it actually expands beyond the slides. MAybe others can see it and can help - I really dont see it on those screenshots - sorry

Also-what is the reason you set the height of the rows to be so big in your template?