Solved: Re: Restricting Values in Chart - Qlik Community

cbaqir · ‎2015-10-07

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?

Clever_Anjos · ‎2015-10-09

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

View solution in original post

Clever_Anjos · ‎2015-10-07

Would you mind sharing a sample of your data or qvw?

Preparing examples for Upload - Reduction and Data Scrambling

cbaqir · ‎2015-10-07

See sample.

Clever_Anjos · ‎2015-10-07

Good night, Cassandra.

How are that tables are supposed to be relationated?

vikasmahajan · ‎2015-10-08

Check Request_id field whether it is same ROLE_ID if yes the while loading DM_STAT_REQ data say REQUEST_ID as ROLE_ID qlikview automatically join with DM_DYN_RESOURCE table.

HTH

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Anonymous · ‎2015-10-08

Script:

table 1:

LOAD

USER_ID

,
ROLE

,
ROLE_ID

FROM

C:\Users\v_0095\Desktop\recipients.xlsx
(ooxml

, embedded

labels

, table

is

DM_DYN_RESOURCE);

table 2:

LOAD

USER_ID

,
EMAIL_ADDRESS

,
FULL_NAME

as

RESP_PROJ_MANAGER

FROM

C:\Users\v_0095\Desktop\recipients.xlsx
(ooxml

, embedded

labels

, table

is

DM_STAT_RESOURCE);
Left

Join

LOAD

REQUEST_ID

,
RESP_PROJ_MANAGER

,
'Y' as

flag

FROM

C:\Users\v_0095\Desktop\recipients.xlsx
(ooxml

, embedded

labels

, table

is

DM_STAT_REQ);

Result is one name you found with flag Y

Regards,

Zain.

Report Inappropriate Content · ‎2015-10-08

Table1:

LOAD

USER_ID

,
ROLE

,
ROLE_ID

FROM

C:\Users\v_0095\Desktop\recipients.xlsx
(ooxml

, embedded

labels

, table

is

DM_DYN_RESOURCE);

Table2:

LOAD

USER_ID

,
EMAIL_ADDRESS

,
FULL_NAME

as

RESP_PROJ_MANAGER

FROM

C:\Users\v_0095\Desktop\recipients.xlsx
(ooxml

, embedded

labels

, table

is

DM_STAT_RESOURCE);
Left

Join

LOAD

REQUEST_ID

,
RESP_PROJ_MANAGER

,
'Y' as

flag

FROM

C:\Users\v_0095\Desktop\recipients.xlsx
(ooxml

, embedded

labels

, table

is

DM_STAT_REQ);

Only one record you found with flag 'Y' which is listed in RESP_PROJ_MANAGER table.

Regards,

Zain.

cbaqir · ‎2015-10-08

I was loading RESP_PROJ_MANAGER as FULL_NAME

cbaqir · ‎2015-10-08

No. Request ID and Role ID are not the same.

Clever_Anjos · ‎2015-10-08

Cassandra, checking your data, there is no person who is at the same time in the two tables