topic Re: Nprinting filter issue in Qlik NPrinting

Nprinting filter issue

Anonymous — Mon, 12 Jun 2017 12:26:12 GMT

Hi,

I am getting this weird behaviour whilst running the task.

I have used a column called organisations in the qlivkiew which has 2 values.

I have created a report with each filter for the respective values.

I have created recepient folders () to save the output folder respectively.

But it is creating report for only the last filter added in the list.

Here in the screenshot Cambridge is coming not birmingham.

How to make it work ?

Any help from the nprinting experts?

Here are the screenshots

regards,

vamsi.

Re: Nprinting filter issue

Lech_Miszkiewicz — Tue, 13 Jun 2017 00:04:50 GMT

Hi,

behaviour is not weird - it is expected! NPrinting is a user who applies selection like a normal person when generating reports. Therefore it tries to generate report and applies as per your screenshot first bgm and at the same time "cambridge" filter. That basicly means "Cambridge" filter stays as the "BGM" is excluded automaticly from selection
In order to create report with filters to respective folders you need to create recipients or group of recipients. Lets just assume you can create 2 recipients and call them "Cambridge" and "BGM". When creating recipients you can also creat RECIPIENT filters - there you need to place your respective filters.
Add those recipients to your report generation task - DO NOT ADD filters anymore!!! as they are already added for respective users
trigger task - observe results

To summerise:

you are applying filters in wrong place. If you want to have different filters for different people/recipients or groups

you need to edit recipients and make sure those filters are part of recipient properties.
then you don't have to add filters to report (just add recipients which will carry filters with them)
note that for each recipient you will get a separate file generated according to their respective filters

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: Nprinting filter issue

Anonymous — Wed, 14 Jun 2017 09:31:59 GMT

Hi Lech,

Very many thanks for your reply and really appreciate it.

I will try with your suggestions and will let you know if that is giving the correct results.

Much oblige.

vamsi.

Re: Nprinting filter issue

Anonymous — Wed, 14 Jun 2017 09:39:40 GMT

Absolutely brilliant lech.

I was literally stabbing in the dark.

I tried many times of adding the filters here and there and given recepients.

But your answer is just straight forward.

Brilliant. you are a savior.

Many thanks. How often you come to this forum ? I want to keep in touch with you for all good reasons.

regards,

vamsi.

Re: Nprinting filter issue

Anonymous — Wed, 14 Jun 2017 10:03:41 GMT

Hi lech,

Thanks for your reply again.

I have got 2 more questions.

1. How can I apply the one more filter for the date to select , in my case we run these reports every end of the month .previously i used to apply the date filter and cycle through the organisations .But as the requirement changed how can i add one more filter to the already existing recipient filter.

2. Message endpoint are not displaying in the reports, qlikview is showing those message end points. i have not changed any code or nothing.

i am attaching those screen shots.

can you please help me when ever you have time.

regards,vamsi.

Re: Nprinting filter issue

Lech_Miszkiewicz — Wed, 14 Jun 2017 12:08:09 GMT

I am here every day - always happy to help

cheers

Lech

Re: Nprinting filter issue

Lech_Miszkiewicz — Wed, 14 Jun 2017 12:16:48 GMT

First question you need to answer is: Is the date filter the same for all recipients? If yes - then you can simply apply this filter on report or task and have a combination of a date beeing applied on report/task level and for each recipient it will apply respectively bgm / cambridge filter

you can have multiple fields beeing a part of recipient filter, so just create your date filter in filters and then edit recipient an add ( + ) it to filter list on recipient properties page

hope this helps

Re: Nprinting filter issue

Anonymous — Wed, 14 Jun 2017 12:46:16 GMT

Ok thank you lech it has worked as My date filter will be the same for all the recepients.

But its good to know you have told me to have different date filters to the different recipients.

Also, any suggestions what must have happened to the second one, as my message points are not showing up in the nprinting where as i can see in qvw.

your knowledge on nprinting is remarkable.

Re: Nprinting filter issue

Anonymous — Wed, 14 Jun 2017 13:26:15 GMT

Hi lech,

I am bogged down with one thing after the other.

I have a report called League table that shows all the organisations and its values.

I have given a date filter 'May 2017' at the report level.

I have used 3 recepient filters with recepient output. and linked to the task,

My requirement is to produce this league table report to all the organisations.

so i have spinned across 3 organisations to see whether it is working or not .

First and second organisation showing the table but without organisation names.

Third one shows just one row without organsiation name .

Pls help me what is happening here.

Here are the screenshots.

Re: Nprinting filter issue

Lech_Miszkiewicz — Wed, 14 Jun 2017 23:55:11 GMT

Hi. To andwer this question i would have to see what is a formula for your message point. Is it a dimension or expression? Is it field or calculated field. What is its representation? Is it maybe text, picture or maybe url.

Can you share your qvw file? Maybe scramble some data and reduce sie of qvw file and paste it here so i can look at it.

Else it is dofficult to see how it should be working

Cheers

Lech

Re: Nprinting filter issue

Anonymous — Thu, 15 Jun 2017 09:23:10 GMT

Hi,

Yes it is a dimension.

I am attaching the qvw, you can see in the summary statistics Tab in qvw

Also, Does the nprinting behave strangely if you start adding any filters to the existing report and run the task bcos as I told you earlier that the organisation names were started disappearing after adding the filter to the league table(first tab in qvw).

Please throw your suggestions.

Regards,

vamsi.

Re: Nprinting filter issue

Lech_Miszkiewicz — Thu, 15 Jun 2017 13:06:41 GMT

Hi,

What NPrinting version are you using? Is it version 16.6? Just want to know as i tested it with version 17 and both Organisation and Message_Endpoints are coming through properly.

When you apply filters in NPrinting it should not behave strangely - at least it does not happen to me, and i have never come accross issues with filters in NPrinting - they work exactly like "you trying to apply all the filters in app"!

Can you refresh metadata in your NPrinting connection and re-create a report template & template nodes as they could become inactive if something has change in source document.

regards

Lech