User Filter

[adrianfer]

I have a report which i want to distribute to a list of Users, where they will only get data specific to them. I have created the recipient list, with the filters and added them to a group...as stated here https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Nprinting-Scheduling-reports-to-multiple-us...

Sample Data:

SEND	Info	User
Yes	Info_X	X
Yes	Info_Y	Y
Yes	Info_Z	Z
No	Info_A	A

Now I have the filters based on User and a Report Filter named FilterSend (where it filters the report where SEND='Yes').When I run task, it generates fine for Users X,Y,Z. But for User A, it includes all the records.

How do i not make it generate anything for User A? Should I re-generate the recipient list and import it everytime i need to send out emails, to be sure that it will only execute the User Filters that will result in valid records?

[lironbaram · Accepted solution]

hi 

you can create a condition in nprinting based on your SEND column

1. create a variable in the Qlik app , vSend with this expression : =ONLY(SEND)

2.create a condition in nprinting using the vSend variable 

3. assign the condition to the relevant reports 

[Ruggero_Piccoli]

Hi,

More details about conditions are in the help site page https://help.qlik.com/en-US/nprinting/November2019/Content/NPrinting/ReportsDevelopment/Conditions.h...

Best Regards,

Ruggero