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