Losing Background Colour Formatting

[MrAndrews]

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

[Frank_S]

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

[stevejoyce]

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

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. 

cheers

[MrAndrews]

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

[MrAndrews]

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]

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]

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!