Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
MrAndrews
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...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. 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
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi @MrAndrews 

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

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

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

MrAndrews
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?

 

 

MrAndrews
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!