topic Re: Conditional Formatting with Pivot in App Development

Conditional Formatting with Pivot

Kaushik2020 — Thu, 13 Mar 2025 04:20:01 GMT

Dear All,

I am using a pivot table in Qlik Sense November 2024 version. i have applied multiple conditions to show the cell background. While exporting a pivot, I do not see an option to export with formatting same as a table. Is there any way I cam achieve this ? PSB sample screenshot.

below is the option which I get when exporting data from a Pivot.

thanks in Advance.

Re: Conditional Formatting with Pivot

Chanty4u — Mon, 17 Mar 2025 15:10:36 GMT

it does not retain the conditional formatting applied in Qlik.

You can use nprinting to get your desired output

Re: Conditional Formatting with Pivot

Kaushik2020 — Sat, 22 Mar 2025 10:06:53 GMT

thanks for the reply, understanding the cost of NPrinting License cost, for just 1 license to extract this in excel I would not recommend the same. this functionality is available in Cloud. May or may not be it will come to Premise versions.