topic Re: Restricting Values in Chart in QlikView

Restricting Values in Chart

cbaqir — Wed, 07 Oct 2015 20:18:25 GMT

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?

Re: Restricting Values in Chart

Clever_Anjos — Wed, 07 Oct 2015 20:50:34 GMT

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

Preparing examples for Upload - Reduction and Data Scrambling

Re: Restricting Values in Chart

cbaqir — Tue, 18 Aug 2020 16:00:08 GMT

See sample.

Re: Restricting Values in Chart

Clever_Anjos — Thu, 08 Oct 2015 01:10:42 GMT

Good night, Cassandra.

How are that tables are supposed to be relationated?

Re: Restricting Values in Chart

vikasmahajan — Thu, 08 Oct 2015 04:20:57 GMT

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

Re: Restricting Values in Chart

Anonymous — Thu, 08 Oct 2015 05:06:40 GMT

Script:

table 1:

LOAD

USER_ID

,
ROLE

,
ROLE_ID

FROM

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

, embedded

labels

, table

DM_DYN_RESOURCE);

table 2:

LOAD

USER_ID

,
EMAIL_ADDRESS

,
FULL_NAME

RESP_PROJ_MANAGER

FROM

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

, embedded

labels

, table

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

DM_STAT_REQ);

Result is one name you found with flag Y

Regards,

Zain.

Re: Restricting Values in Chart

Thu, 08 Oct 2015 05:11:22 GMT

Table1:

LOAD

USER_ID

,
ROLE

,
ROLE_ID

FROM

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

, embedded

labels

, table

DM_DYN_RESOURCE);

Table2:

LOAD

USER_ID

,
EMAIL_ADDRESS

,
FULL_NAME

RESP_PROJ_MANAGER

FROM

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

, embedded

labels

, table

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

DM_STAT_REQ);

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

Regards,

Zain.

Re: Restricting Values in Chart

cbaqir — Thu, 08 Oct 2015 14:33:12 GMT

I was loading RESP_PROJ_MANAGER as FULL_NAME

Re: Restricting Values in Chart

cbaqir — Thu, 08 Oct 2015 14:33:58 GMT

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

Re: Restricting Values in Chart

Clever_Anjos — Tue, 25 Aug 2020 14:45:47 GMT

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

Re: Restricting Values in Chart

cbaqir — Thu, 08 Oct 2015 15:13:15 GMT

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.

Re: Restricting Values in Chart

Clever_Anjos — Fri, 09 Oct 2015 12:32:09 GMT

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

Records into DM_STAT_REQ have no correspondence into DM_STAT_RESOURCE

Re: Restricting Values in Chart

cbaqir — Fri, 09 Oct 2015 15:36:06 GMT

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?

Re: Restricting Values in Chart

Clever_Anjos — Wed, 19 Aug 2020 18:08:39 GMT

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

Re: Restricting Values in Chart

cbaqir — Fri, 09 Oct 2015 17:05:55 GMT

Thanks!