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

Qlik NPrinting Nov 2017 - Issues with excel filters and Icons

bjarnepedersen — Wed, 09 May 2018 12:24:15 GMT

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

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

Lech_Miszkiewicz — Mon, 14 May 2018 22:02:19 GMT

I think you forgotten add your actual template screenshot - we can't see how your template is buil

Just few quick tips and questions:

Do you use:

expand range?
range table vs (excel insert) ->table?
by the way..i used to add extra column with value for my condition (to calculate condition for arrow direction) so i can reference conditions horizontally..

The best would be if you could export your report template and attach here so we could exactly see how it is built

regards

Lech

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

Lech_Miszkiewicz — Mon, 14 May 2018 23:38:47 GMT

I just tested it

1. when i create a formatting rule for a column i do not specify cells like you do.... $A$4 $A$11

instead i select whole column to be checked for conditional formatting...

like this:

2. You must have added table to your range - this is the reason why you see filter "caret" icon

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

bjarnepedersen — Tue, 15 May 2018 09:23:46 GMT

2. Yes we have added a table but in all settings in the NPrinting we have deselected the filter. But it is still visible in the preview and output when we choose excel. So is it possible to deselect or get rid of these filters or is it a standard when you have chosen a table?

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

Lech_Miszkiewicz — Tue, 15 May 2018 09:35:19 GMT

yes - this is standard (default) Table setting in ms excel.

You can adjust it in Table settings (there is option called: "Filter button") - It is not the usual Filter icon you shown, but a checkbox on table ribbon settings.

regards

Lech

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

bjarnepedersen — Tue, 15 May 2018 09:39:58 GMT

Yes I found it and it is unchecked so that is why I wonder why we still get the filter in output/previews

Brg Bjarne

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

Lech_Miszkiewicz — Tue, 15 May 2018 09:43:47 GMT

Right - i will have to test it and see . Maybe you have just discovered a bug:)

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

bjarnepedersen — Tue, 15 May 2018 11:42:58 GMT

Hmm. Lets see what your test shows

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

bjarnepedersen — Tue, 15 May 2018 11:44:28 GMT

1. No matter if I choose the hole column or some cells from it. I do only get the arrow visible in the first lines.. Any other ideas why this do not work for the entire column?

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

Lech_Miszkiewicz — Tue, 15 May 2018 12:47:51 GMT

Ok so here are my findings.

First and foremost - there is no Bug - and everything works as it should. If you are not getting filters removed there is definitely something wrong with your template. Regarding conditional formatting not working for you - I have the feeling that your numbers are formatted as a text and therefore conditional formula cannot be properly evaluated.

Below are the steps i have done to reproduce this case:

I have added to table entities my table wit 3 dimensions and 3 measures. I have disabled "Keep source formats" and dragged and dropped nodes to excel template

Next step was to convert range to table by inserting a table - note what range i have selected.

In the next step i have gone to Table Tools--> Design and unticked Filter Button checkbox - this prevents filters from coming up. I have also made sure that Expand range is selected to make sure that my table will "expand"

Last step was to apply conditional formatting. To be frank i did not have to select whole column, but only cells within my table range. Note the type and values i am selecting.

here you can see results (see attachement)

cheers

Lech

---------------------------------------------

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 as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

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

bjarnepedersen — Wed, 16 May 2018 07:20:05 GMT

Hi Lech Thanks for testing and answers. Point 2 (conditional formatting) is solved by using exact values instead of formulas as you mentioned. Point 1 is still the same even though we do exact the same as you have done here. We still get the filters in output/preview. We are using NP November version. Can that have something to say? Brg Bjarne

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

Lech_Miszkiewicz — Wed, 16 May 2018 08:55:49 GMT

I am using always the latest version of NPrinting and i am using Office 365 local version AKA 2016. I would blame it on ms office rather than nprinting.

regards

Lech