Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

multiple bar graphs from different tables

Hi

I would like to create a multiple bar graph shown as in the attachment.

The input values to the bar graph are from 2 different tables, can anyone tell me how can I do this one.

Please find the attachments.

2 Replies
Anil_Babu_Samineni

I recommend you to rename the Name using resident

Load Person ID, Reviewer, Marks From Source1;

Load Person ID, Reviewer, Marks1 From Source2;

OR

QUALIFY Marks;

T1:

Load * Inline [

Person ID, Reviewer, Marks

P1, R1, 25

P2, R2, 30

P3, R1, 23

P4, R3, 45

P5, R1, 50

P6, R4, 28

];

UNQUALIFY *;

QUALIFY Marks;

T2:

Load * Inline [

Person ID, Reviewer, Marks

P1, F1, 30

P2, F2, 20

P3, F3, 25

P4, F1, 20

P5, F2, 40

P6, F3, 30

];

UNQUALIFY *;

Output Seems This

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

Hi

Could you explain briefly how can I do the above one (procedure) ?