Bar Graph with two measures from different tables

[#1]

Hi All,

I am new to QlikSense and I am just getting a hang of getting things done here.

I want to know how to have two measures from two different tables with the same dimension in a Bar graph. Specifically, I have two tables - Polled and Responded in the Data Model. Both these tables have Year, Quarter and Account as common fields. Now I want a bar graph with Quarter as the dimension and Count of Polled and Count of Responded as measure.

Please help...

Milan

[Gysbert_Wassenaar]

It depends on how the two tables are linked. But in principle it's no problem to create measures using fields from different tables.

[#3]

Joining or concatenating the tables by the common fields should make this possible. I would also look at associating by account and using a master calendar for dates. Once loaded, have a look at your subset ratio and info density to confirm validity.