topic Re: Importing Qlik Sense Pivot table into NPrinting Excel Report - Color expression in Qlik NPrinting

Importing Qlik Sense Pivot table into NPrinting Excel Report - Color expression

miguel_m_cunha — Mon, 07 Oct 2019 15:10:51 GMT

Hello,

I'm trying to import a Qlik Sense Pivot table straight into a Qlik NPrinting Excel Report but when I do that the table on NPrinting doesnt come with the color expression as it is in the Qlik Sense App.

I also replicated the pivot table as a straight table (in the qlik sense app) and NPriting is able to recognize the color expression in the staight table.

Why doesn't it work in the Pivot table?

Best Regards,

Miguel Cunha

Re: Importing Qlik Sense Pivot table into NPrinting Excel Report - Color expression

Frank_S — Mon, 07 Oct 2019 17:10:35 GMT

Hi @miguel_m_cunha

I got the same result.

There is clearly a functional difference between the way NPrinting handles a color expressions for a table vs a pivot table.

I suspect that the pivot report is produced 'before' the expression can be applied.

So I have submitted an internal defect investigation. Please use this ID for tracking purposes.

OP-8912: NPrinting report export does not respect color expressions for QS Pivot Tables

In the meantime, since this is a public forum, I also suggest that you start a support case and share the defect information so that this can be formally tracked and followed up.

Kind regards...

Re: Importing Qlik Sense Pivot table into NPrinting Excel Report - Color expression

miguel_m_cunha — Tue, 08 Oct 2019 08:05:51 GMT

Hi @Frank_S ,

Thanks for your answer. I will open a support case.

Best Regards,

Miguel Cunha

Re: Importing Qlik Sense Pivot table into NPrinting Excel Report - Color expression

Frank_S — Tue, 08 Oct 2019 13:02:38 GMT

Hello @miguel_m_cunha

I received a response from R&D and unfortunately this is actually a limitation at this time.

Please see the following link https://help.qlik.com/en-US/nprinting/February2019/Content/NPrinting/ReportsDevelopment/Qlik-objects-supported-NP.htm#pivot.

Kind regards...

Re: Importing Qlik Sense Pivot table into NPrinting Excel Report - Color expression

miguel_m_cunha — Tue, 08 Oct 2019 13:16:19 GMT

Hi @Frank_S

Yeah, they gave me the same aswer in the Support portal.

I'll have to wait and see if this will be fixed in the next release!

Thank you once again!

Miguel Cunha