topic Re: NPrining Nov 19 User Filter and Email in Qlik NPrinting

NPrining Nov 19 User Filter and Email

jagjivvt — Tue, 31 Mar 2020 16:31:14 GMT

Hi all,

I have a user who can receive reports based on more than one entity, when i run the report, it only created reports for entities that have a single filter and ignores the rest.

User Email Filter

A a@a.com A,B

C c@c.com C

it will create report for C but not for A or B

Is there some setting that i am missing

thanks

this is the error message i get

Failed resolution for variable V\vMIStart of connection 84f18b56-8fc2-4148-a80e-e2875282b465: Cannot resolve content for node Variable_User_GSK_Invoice_Creation_vMIStart (object: V\vMIStart) due to invalid selections: Filters: [Fields: [Name: F\BP_Real_Date, ConnectionId: 84f18b56-8fc2-4148-a80e-e2875282b465, Values: [AdvancedSearch:23/03/2020], Override: False, Void: False, SelectExcluded: False], Variables: [], Void: False Fields: [Name: F\Supplier, ConnectionId: 84f18b56-8fc2-4148-a80e-e2875282b465, Values: [AdvancedSearch:Allegis Group, Aston Carter], Override: False, Void: False, SelectExcluded: False], Variables: [], Void: False], Bookmark: , Void: False

Re: NPrining Nov 19 User Filter and Email

Lech_Miszkiewicz — Wed, 01 Apr 2020 00:33:41 GMT

If you thought that user A with email a@a.com would receive 2 separate reports one for filter A and one for filter B or one report including both filters you missed it by far 🙂

Filters are like selections. When you take selections from A & B filter those selection will be applied all at once using "AND" logic. In your case such selection is not possible or results in empty string because if you selected A and in the next step you are selecting B you are deselecting A. Solution for it can be 1 filter where you would select A&B.

Please search community for multiple examples of the same.

I also suggest you start from reading documentation first and rules on how filters work.

https://help.qlik.com/en-US/nprinting/November2019/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.htm#anchor-3

among rules this is the one you are likely experiencing:

If the intersection gives an empty result, the filter chain will become invalid.

It seems like you will have to change the way of thinking around this report.

Re: NPrining Nov 19 User Filter and Email

Lech_Miszkiewicz — Wed, 01 Apr 2020 00:35:34 GMT

sidenote: your advanced search filter looks little bit odd.. Can you share screenshot how you configured it NPrinting and reason why haven't you used a value filter?

Re: NPrining Nov 19 User Filter and Email

jagjivvt — Wed, 01 Apr 2020 07:35:58 GMT

Hi Lech,

Thank you. I have set up filter see attached screen grabs.

I have Allegis Group and within that there are 2 suppliers. The report needs to be for each supplier and goes to same email address. The data for both is different.

thanks

vijay

Re: NPrining Nov 19 User Filter and Email

Lech_Miszkiewicz — Wed, 01 Apr 2020 07:47:31 GMT

first thing first

Filter - instead of using Advanced search (which is bit weird the way you set it up use just Value is) like this:

that will ensure that your filter is correct to filter out data.

Now how do you want to achieve 2 seperate reports?

Are you using Cycle function and cycle over supplier field?
or Are you using Page or Level function within single report?

Using a filter will not help you achieve 2 separate reports for 2 suppliers...

Re: NPrining Nov 19 User Filter and Email

jagjivvt — Wed, 01 Apr 2020 08:11:03 GMT

Hi Lech,

On reading the link you sent me, i have corrected my filters, the error i was doing was inserting both suppliers in 1 selection.

thank you for all you help.