Excel Conditional Formatting and Borders

[mlin]

I have a chart in QlikSense and I'm exporting it to nprinting, but if I keep source formats, I can't add borders. If I deselect keep source formats, I can add borders, but I lose the conditional formatting that comes from the app.

Is there a way to 'keep source formats' for the conditional formatting to pass through, but be able to add cell borders? It doesn't seem like you can add the cell borders within the chart in QlikSense.

Do not keep source formats:

Keep source formats:

[Lech_Miszkiewicz · Accepted solution]

no there isnt'

The workaround is is to remove "Keep source format" and apply conditional formatting in excel. 

If formula for conditional formatting is complex you can add additional columns to your Qlik Sense table which will have values indicationg what conditional format needs to be applied in Excel. Then you export those additional columns to hidden columns in Excel and referemce them to get required format. 

I use this approach on all my projects where required and it works ok

cheers

[mlin]

If you store the conditional formatting as additional columns and hide them, then you can't view them in nprinting/excel either.. How do you bypass that?

[Lech_Miszkiewicz]

Hi,

You hide them in excel not in Qlik Sense. In Qlik Sense I prepare dedicated object (with those additional columns) so it does not interrupt the object used by users

[seanbruton]

Kudos nice solution!!