Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Garfunkal
Contributor III
Contributor III

Losing Background Colour Formatting

Hi

So I have a straight table, which has a few columns with a conditional formatting on some backgrounds.  When i try to use nPrinting to represent the table as an Excel table, all the formatting is lost.  I've searched quite a bit - but i'm not even sure if this should be possible.  I have followed the advice such as using source formatting etc, but I don't get the colours as required.

My condition is not very complicated:  IF( [Overall Plan Compliance] < 50, '#cc3232', IF ([Overall Plan Compliance] = 100, '#2dc937', '#e7b416'))

I've added screenshots of the table, and the template.

Using nPrinting Feb 2021 and Qlik Sense Feb 2021

Labels (2)
7 Replies
Frank_S
Support
Support

Hi

Can you test that in an Excel Spread Sheet first? Does it work there? I'm just wondering if MS excel allows it.

In your testing, you should also uncheck the 'keep source format' check box on the top chart object in the NP designer and each individually expanded field object beneath the top table chart.

 

Let us know,

 

Kind regards...

We are just 'like' you and like to be liked when providing a helpful answer. You may also press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
stevejoyce
Specialist II
Specialist II

Is [Overall Plan Compliance] a master item by chance?  i don't know if column header reference also has an issue, but i know i had an issue when writing an expression referencing a master measure/dimension.

If so, replace"[Overall Plan Compliance]" with the master item's expression in your color expression.

Lech_Miszkiewicz

Hi @Garfunkal 

in your screenshot you are showing us only properties on the table level. What do you have when you look at individual field properties like on gif below? Are fields also having "Keep Source Formats" checked?

I have done my testing and referencing master measures in colours worked for me on NPrinting version May 2021 SR2.

Lech_Miszkiewicz_0-1635979412184.gif

The other option is that you may have conditional formatting set in your excel template (just usual conditional formats) which override settings you are bringing in from Qlik Sense. It is worth checking just to exclude that possibility. 

Lech_Miszkiewicz_1-1635979514777.png

cheers

 

 

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

Hi Steve - no - it's a field straight from the script - I pushed the processing into there.

Garfunkal
Contributor III
Contributor III
Author

Hi 

 

I'm not sure how I could put the expression into Excel?  If i build it via conditional formatting native to excel it works in the Previewed spreadsheet.  

In terms of Keep source format.... In the first version I added had some expressions in the Dimensions, so it doesnt have the option to expand each field object.  I created a cut down version with two fields, and followed you advice, but sadly it didnt have any affect.  Screenshot attached.

Garfunkal
Contributor III
Contributor III
Author

Hi - i'm afraid this didnt work - But you say master measures... Would this only work for Measures, and perhaps only masters?  I can't perhaps use this on dimensions that are derived, or even from the script?

 

 

Garfunkal
Contributor III
Contributor III
Author

Hi - I did as you suggested, this time with a measure, and again with a master measure, but no dice! I can only assume i'm doing something really weird!