Qlik NPrinting

[bobbydave]

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

[bobbydave]

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.

[Ruggero_Piccoli · Accepted solution]

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.

[bobbydave]

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

[Ruggero_Piccoli]

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

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

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.

[bobbydave]

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

[Ruggero_Piccoli]

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.

[bobbydave · Accepted solution]

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

Thanks again Ruggero

[bobbydave]

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.