Qlik Sense Nprinting Losing Conditional Formatting - Qlik Community

mfarr13 · ‎2022-10-12

As the title suggest, when we are importing directly a table from a qlik sene report, the conditional formatting which was applied to said table is being lost. Is there any way to do this? Are there any available extensions?

Is there a way to do this without having to individually import the fields one by one to create a pivot table in the report editor? We require it to work as we need conditional formatting to be applied to individual cells depending on their numerical value.

TIA

Ruggero_Piccoli · ‎2022-10-12

Hi,

When posting new questions in the community please add the label with the correct version of the software you are using because the answer could depend on it. Add also all the details that could help us to reproduce your issue, for example, the type of the template you are developing (I suppose Excel) and some screenshots of it. Thanks

Qlik NPrinting does its best efforts to keep the original formats but sometimes it could not be possible. More details about unspported stuff are listed in https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/ReportsDevelopment/Qlik-objects-supp...

The workaround is the one you mentioned: recreate a native Excel table or pivot table and use Excel conditional formatting features.

Best Regards,

Ruggero

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

mfarr13 · ‎2022-10-12

Hi Ruggero, thanks for the swift reply.

I have gone through your link and could see that when importing a pivot table; foreground and background colors are not supported. What would you suggest we can use to as a 'highlight' for the user ? Can we use somehow font size and font color for numerical values say if they exceed / are below a certain threshold?

The user wants to be able to be 'notified' through a quick glance rather than going through all values. We cannot really recreate all of our reports throuh individual objects as we have over 200 reports and it would take a very long time.

Ruggero_Piccoli · ‎2022-10-12

Hi,

I agree, you could try different formats than colors like bold font etc. You could also try to export only the objects with "alerts" as images. I know they will not have data but you can add tables with details.

Best Regards,

Ruggero

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

Lech_Miszkiewicz · ‎2022-10-12

Hi, So what is the problem in converting it into Excel Pivot Table? and using conditional formatting there?

Are you just trying to avoid any NPrinitng development and have rather simple drag&drop object template?

cheers

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.

mfarr13 · ‎2022-10-12

Yes that is the case. We have already set up the required conditional formatting with the Qlik Apps themselves so this would be double the work having to do it all again.

Lech_Miszkiewicz · ‎2022-10-12

Ok - well the only way of doing this then is to use Image node - not ideal though and I do not recommend it. I would still do it with straight table and conditional formats. Usually it is not that hard if data is prepared properly.

As Qlik partners we usually set the expectations with clients what is possible and what isn't and prepare clients for extra work which is required to deliver nicely formatted reports with NPrinting or at least provide info what possible outcomes you can get. all Required info is on https://help.qlik.com and usually clients are willing to spend this extra time on development if results are acceptable.

cheers and good luck

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.