Restricting Values in Chart

[cbaqir]

I am using a QlikView Entity as a recipients list for an Nprinting report.

My recipients list in my chart has more people than I need in it. It is showing ALL Users. I want to restrict it to anyone that exists in another field in my QVW. How would I get my chart to show only the names of people that are currently listed in a field called RESP_PROJ_MANAGER?

[cbaqir]

Let me rephrase. The DM_STAT_RESOURCE table contains all users. All I want in the table is users that are listed as a RESP_PROJ_MANAGER in DM_STAT_REQ.

[Clever_Anjos]

It´s what I´m trying to say to you.

Records into DM_STAT_REQ have no correspondence into DM_STAT_RESOURCE

[cbaqir]

I know that. What I am trying to accomplish is basically a lookup of the Resource name into the STAT_REQ table on the RESP_PROJ_MANAGER field. If the user is listed as a RESP_PROJ_MANAGER, I want to see their information in my table. Does that make sense?

[Clever_Anjos · Accepted solution]

There´s more than a way of doing that, Cassandra.

Please find attached one possible solution.

I´ve created a Flag inside your DM_STAT_RESOURCE that means

• 1 - It´s related to a record into STAT_REQ
• null - It isn´t related to a record into STAT_REQ
•  
•  

[cbaqir]

Thanks!