topic Re: selection not working in nprinting on demand with linked Field in Qlik NPrinting

selection not working in nprinting on demand with linked Field

santlal0589 — Sun, 30 Jul 2017 19:09:08 GMT

Created word report with multiple connection with QVW.(connection as QVW1Connect , QVW2connect)

Created linked field City.(Keep matched value only)

When doing selection in City field in On- Demand APP selection is applied on object of only one APP.

In connection ID Attribute of on-demand added QVW1Connect

but selection is happening on QVW1 only.

Kindly help.

Re: selection not working in nprinting on demand with linked Field

Ruggero_Piccoli — Mon, 31 Jul 2017 09:54:39 GMT

Hi,

This is works as design. We are speaking about Qlik NPrinting 16.* because you mention linked fields that are not available in 17.*.

Qlik NPrinting 16.* with On-Demand uses only current selections of the document where you made the selections.

As workaround you can create Qlik NPrinting filters and use them via On-Demand.

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: selection not working in nprinting on demand with linked Field

santlal0589 — Mon, 31 Jul 2017 10:02:39 GMT

Kindly elaborate you point.

How to do as per your suggestion.

Re: selection not working in nprinting on demand with linked Field

Ruggero_Piccoli — Mon, 31 Jul 2017 14:00:07 GMT

Create the linked field to link the city field from two .QVWs
Create the filters you think you need by using the city linked field. For example create the filters: Ottawa, Lund, New York
In the load script of the .QVW that you use as On-Demand User Interface add the load of a field with the name of the created filters. Something similar to
AdditionalLinkedCityFilters:
LOAD * INLINE [
LinkedCityFilterID
LinkedFieldCityFilterNewYork
LinkedFieldCityFilterLund
LinkedFieldCityFilterOttawa
];
In the .QVW that you use as On-Demand User Interface add a listbox that shows the LinkedCityFilterID
Add an On-Demand report button configured to run the report you want and in the Filter Setting - Additional saved filter add the formula =GetFieldSelections(LinkedCityFilterID,',') & ''. This read the selection a user do in the listbox previously added
Select a filter and run the report

Re: selection not working in nprinting on demand with linked Field

santlal0589 — Tue, 01 Aug 2017 05:39:43 GMT

Can you suggest how to handle if City field has 50 values.

Do i need to create 50 filters?

Re: selection not working in nprinting on demand with linked Field

Ruggero_Piccoli — Tue, 01 Aug 2017 07:55:50 GMT

Yes, if the City field has 50 values and you must keep the two .QVWs separete you must create 50 filters with the solution I suggested.

Another idea is to create a new .qvw and use it as source for Qlik NPrinting. This qvw reads data from the two other sources and you creates On-Demand report from it so you can use current selections. Another advantade to do this is that the .qvw for NPrinting can be optimized to reduce report creation time.

Best Regards,

Ruggero

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

Re: selection not working in nprinting on demand with linked Field

gs_qlik_nl — Fri, 04 Aug 2017 12:02:10 GMT

Hi Ruggero,

Thanks for the explanation. But I still cannot get the linked fields working with OnDemand. Can you give a more detailed explanation at point 4 and 5 in the how to. Which filters do I need to create on the NPrinting Task. How does NPrinting know that =GetFieldSelections(LinkedCityFilterID,',') & ''. connects to that field in Qlikview?

Kindly a more detailed explanation.

Kind regards, Gerald

Re: selection not working in nprinting on demand with linked Field

Ruggero_Piccoli — Fri, 04 Aug 2017 13:23:02 GMT

Hi,

You can give a check at the attached example. It contains:

an NPrinting project with the linked field and the filters
the .qvw Sales Demo for Ajax that is the user interface for On-Demand. The script loads the filter names that are displayed in the list box so you can select the one you want to apply before to run the on demand request
the two QVWs used as data source

The example implemented the solution I explained. The template is a very simple Excel example.

=GetFieldSelections(LinkedCityFilterID,',') & '' is inserted in the Filter settings of the On-Demand report button called "Click here for the Linked Fields Example" in the SalesDemo for Ajax.qvw. It retrieves the selected filter name from the list box. Remember to open it in web view.

Let me know if you have more questions.

Re: selection not working in nprinting on demand with linked Field

gs_qlik_nl — Tue, 29 Aug 2017 12:09:54 GMT

Hi Ruggero,

Thank you for the information you've shared. If I run the QVW selecting with Linkedfield = 2011. Then it works fine. If i select another year. Then it doesn't work anymore. Can you check if you can make another yearselectie and the Export selected properly? I couldn't get it working?, of

Kind regards, Gerald

Re: selection not working in nprinting on demand with linked Field

Ruggero_Piccoli — Tue, 29 Aug 2017 13:32:19 GMT

Hi Gerald,

My mistake, sorry, but easy to be resolved:

- open the file C:\NP_Training\NPrintingFiles\OnDemand.nsq

- open the only Excel report

- remove the filter "LinkedFieldYear = 2011" from the report

- save the .nsq file

Re: selection not working in nprinting on demand with linked Field

gs_qlik_nl — Tue, 29 Aug 2017 14:52:10 GMT

No worries, I resolved it and it does work now.

Can I select only two or more LinkedFieldYears? I've tested this but it didn't work.

Thanks!

Kind Regards, Gerald

Re: selection not working in nprinting on demand with linked Field

Ruggero_Piccoli — Tue, 29 Aug 2017 15:16:11 GMT

In the case of the application attached to this conversation, if you select more than one linked filed filter you will get an empty report. This is a consequence of how this specific application is designed and build. If you select at the same time year=2010 and year=2011 you get an empty dataset.

In general you can select more than a filter at a time.