Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
Showing results for 
Search instead for 
Did you mean: 

Qlik NPrinting Nov 2017 - Issues with excel filters and Icons


I have a report from NPrinting created in excel with 2 issues. Hope somebody can help

1) In the output I get excel filters (small arrows) in line nr 1. I can see in the excel output that the filters is on and off course it should show filters. The problem is that in the template filters is not on. So how do I remove this?

2) In the output I also only see the red arrow until line nr 4. I have made the formula (conditional formatting) until line 11. So why does it stop here?

See attached files for screenshots of the problems

Thanks in advance

Brg Bjarne

1 Reply

Re: Qlik NPrinting Nov 2017 - Issues with excel filters and Icons

Hi Bjarne

1 issue

Your screenshot called Template.png does not show anything meaningful now...

You need to provide us a screenshot of a page where the NPrinting tags are used so we can see if they are applied on those particular cells. It is likely that you provided us a screenshot of different sheet.

2 issue.

looks like you are stitching this report from 2 tables given taht on the 4th row you have TOTALS? Maybe show us how this is actually built in NPrinitng?

also maybe check those topics as there are many different reasons for what you are experiencing:

Conditional Formatting in Excel Template

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.