Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Please can you tell me, how the colors you have added in Qliksense reflecting same in Nprinting as well?
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
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
Ok,
one more very important question: What are the expressions you use for colours?
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())
Strange...
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.