topic Re: Excel Conditional Formatting and Borders in Qlik NPrinting

Excel Conditional Formatting and Borders

mlin — Tue, 15 Oct 2024 02:14:50 GMT

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:

Re: Excel Conditional Formatting and Borders

Lech_Miszkiewicz — Tue, 15 Oct 2024 04:39:32 GMT

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

Re: Excel Conditional Formatting and Borders

mlin — Tue, 15 Oct 2024 20:52:21 GMT

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?

Re: Excel Conditional Formatting and Borders

Lech_Miszkiewicz — Tue, 15 Oct 2024 22:58:01 GMT

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

Re: Excel Conditional Formatting and Borders

seanbruton — Tue, 15 Oct 2024 23:33:33 GMT

Kudos nice solution!!