topic Re: nPrinting 18 - Exclude Filter sorta in Qlik NPrinting

nPrinting 18 - Exclude Filter sorta

bobbydave — Wed, 25 Sep 2019 18:40:54 GMT

So I upgraded from NP 16.5 to 18.1

In NP 16.5, within Filters, there was the Select Exclude option. I had excluded countries Luxemburg, N. Ireland from my list of countries in my filter named Countries.

In NP 18, I do understand that you do not have the option to exclude which is why I did the opposite and choose all the countries I wanted.

So when I run my nPrinting report now, in my designer, I have Page object that selects countries in the tab of excel sheets. So eg.

UK tab, USA tab, Belgium tab

The countries from the Pages source works fine but my charts that are associated with this page show ALL (see my expression below).

My chart should say UK incl Off System in the UK tab, USA incl off system in the USA tab etc,

Instead for all these tabs even though they do say the correct country name in the tab, I am seeing

All Incl Off System.

There is absolutely no change from NP 16.5 to the new version 18.1 I imported the charts in fact to test and even when failed, I created a brand new template and all result in the same thing. "All incl Off system

= if(GetSelectedCount(Country)>1 or GetSelectedCount(Country)=0,'All',Country) & ' Claims incl Off-system

Re: nPrinting 18 - Exclude Filter sorta

bobbydave — Fri, 24 Aug 2018 14:51:14 GMT

Also, am I understanding right

include_excluded

Does that mean it is looking for the excluded filtering?

GetSelectedCount()

field_name	The field containing the range of data to be measured.
include_excluded	If set to True(), the count will include selected values, which are currently excluded by selections in other fields. If False or omitted, these values will not be included.
state_name	The name of an alternate state. If specified, the counted value for the field in the alternate state is returned. If no alternate state is provided, the default state is used.

Re: nPrinting 18 - Exclude Filter sorta

Ruggero_Piccoli — Tue, 28 Aug 2018 13:00:47 GMT

Hi,

The "Select excluded" option is still not available in Qlik NPrinting 17+. You must insert the full list of the countries you want to include manually or by importing filters from an Excel file.

You see "All Incl Off System" in all worksheets because you added the field Country in the Pages node from a connection and the chart comes from a different one. If you select the Country field and the cart from the same connection you will get a result similar to the attached one that uses your formula (I copied and pasted it in my template).

Best Regards,

Ruggero

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

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. 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: nPrinting 18 - Exclude Filter sorta

bobbydave — Wed, 07 Nov 2018 15:26:30 GMT

Hey Ruggero,

I came back to this issue.

If I don't add my charts and drop Country into my template and use the <Country_Page>, then I see the Country when generated along with the corresponding country tab.

However, if I re-add my chart which has the title expression

= if(GetSelectedCount(Country)>1 or GetSelectedCount(Country)=0,'All',Country) & ' Claims incl Off-system

It keeps coming back with the Chart titled 'All Claims incl Off-System' and all the charts for each country remain the same.

I don't understand whats different between my working version on NPrinting 16 and the not working NPrinting 18

Re: nPrinting 18 - Exclude Filter sorta

Ruggero_Piccoli — Thu, 08 Nov 2018 11:23:06 GMT

Hi,

I answered in the other conversation. In any case I tested your formula with Qlik NPrinting November 2018 Technical Preview and it works.

Best Regards,

Ruggero

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

Re: nPrinting 18 - Exclude Filter sorta

bobbydave — Wed, 14 Nov 2018 13:27:01 GMT

Hi Ruggero,

Find attached my app. Could you test it and see if it still works for you. You might spot something in my app that i'm not seeing.

It does 100% work on NPrinting 16 but I cannot for the life of me get it to work on 18.

As mentioned before, because I cant use exclude filtering working, I have instead used 'include only what countries I want' manually in the filter

Re: nPrinting 18 - Exclude Filter sorta

Ruggero_Piccoli — Mon, 19 Nov 2018 14:03:46 GMT

Re: nPrinting 18 - Exclude Filter sorta

Ruggero_Piccoli — Mon, 19 Nov 2018 14:04:50 GMT

Hi,

See the attached template. It works on my November 2018 installation.

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. 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: nPrinting 18 - Exclude Filter sorta

bobbydave — Thu, 22 Nov 2018 12:25:27 GMT

Going to upgrade from Sept to Nov release and see if this solves the issue.

Thanks again Ruggero

Re: nPrinting 18 - Exclude Filter sorta

bobbydave — Fri, 30 Nov 2018 11:19:21 GMT

Hi Ruggero,

I'm back to this issue yet again. I've downgraded again to NPrinting 18 Sept. I just cant get Nov release up and running with this cert anyways.

Anyways, I've attached the QVW I am working with.

Can you add it to a test sheet and see if when importing the chart in the qvw, whether the chart detail and the bar chart changes to reflect the country tab name. This is my issue. Its not bringing in the country object to show the tab name. My problem is my chart in the qvw.

Re: nPrinting 18 - Exclude Filter sorta

Ruggero_Piccoli — Fri, 30 Nov 2018 16:04:43 GMT

Hi,

1 - QlikView macros are not supported by Qlik NPrinting, any version. Remove them.

2 - The chart has an error in QlikView document that persists also if you select a specific country. Resolve that error before to use the document with Qlik NPrinting.

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 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: nPrinting 18 - Exclude Filter sorta

mikko_lintunen — Thu, 14 Mar 2019 09:35:51 GMT

So anything new on exluded or possible filter function?

Possible filter needed for making nprinting levels on reports work. Since now all Levels area created to report. It does not matter if they have any sort of relation to selection values. You can make filter on single values but maintenance is huge if all variations are done via specified value since possible selection would do enough.

Exluded filter

And if we need to see which customers did not buy this Chairs product group we need exclude filtering and with single values which are not needed in report.

Re: nPrinting 18 - Exclude Filter sorta

Ruggero_Piccoli — Thu, 14 Mar 2019 11:35:40 GMT

Hi,

Advanced filtering is in the roadmap but not yet available.

Please note that you can add also straight tables and table boxes to the levels node, not only fields. So you could create a straight table or a table box that contains only the list of customers who did not buy a specific product in a time interval and add this new object to the levels node to have a slide for each one.

Best Regards,

Ruggero

Re: nPrinting 18 - Exclude Filter sorta

mikko_lintunen — Thu, 14 Mar 2019 11:44:42 GMT

table seems to work on possible values, thank you!