Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
It´s what I´m trying to say to you.
Records into DM_STAT_REQ have no correspondence into DM_STAT_RESOURCE
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?
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
Thanks!