Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

cbaqir
Valued Contributor

Restricting Values in Chart

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?

1 Solution

Accepted Solutions
Employee
Employee

Re: Restricting Values in Chart

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

14 Replies
Employee
Employee

Re: Restricting Values in Chart

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

Preparing examples for Upload - Reduction and Data Scrambling

cbaqir
Valued Contributor

Re: Restricting Values in Chart

See sample.

Employee
Employee

Re: Restricting Values in Chart

Good night, Cassandra.

How are that tables are supposed to be relationated?

Capturar.PNG

vikasmahajan
Esteemed Contributor

Re: Restricting Values in Chart

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

Highlighted
admin1
New Contributor III

Re: Restricting Values in Chart

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

,
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.

Not applicable

Re: Restricting Values in Chart

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

,
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
Valued Contributor

Re: Restricting Values in Chart

I was loading RESP_PROJ_MANAGER as FULL_NAME

cbaqir
Valued Contributor

Re: Restricting Values in Chart

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

Employee
Employee

Re: Restricting Values in Chart

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