Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

stascher
Contributor

Using one field's value to select records from another table.

Given the following tables

Studies:

load * inline [

study_country,plan_date,plan_count

3_usa,jan-2018,5

3_usa,feb-2018,7

3_usa,mar-2018,10

];


Sites:

load * inline [

study_country,study_site

3_usa,3_boston

3_usa,3_chicago

3_usa,3_philly

];


Subjects:

load * inline [

study_site,subj,enroll_date

3_boston,andy,jan-2018

3_boston,clara,feb-2018

3_philly,janet,feb-2018

];


Is it possible to render a line chart with plan_date as the dimension and two measures:

1) sum(plan_count)       // the planned enrollment for the study_country on any given plan_date.

2) a count of subjects who enrolled on the plan_date; ie enroll_date=plan_date



Thanks.

1 Solution

Accepted Solutions
ogautier62
Valued Contributor II

Re: Using one field's value to select records from another table.

Hi

is this you're expecting ?

regards

2 Replies
ogautier62
Valued Contributor II

Re: Using one field's value to select records from another table.

Hi

is this you're expecting ?

regards

stascher
Contributor

Re: Using one field's value to select records from another table.

Thank you.

Community Browser