topic Re: Bar Graph with two measures from different tables in App Development https://community.qlik.com/t5/App-Development/Bar-Graph-with-two-measures-from-different-tables/m-p/1142122#M20262 <HTML><HEAD></HEAD><BODY><P>It depends on how the two tables are linked. But in principle it's no problem to create measures using fields from different tables.</P></BODY></HTML> Tue, 07 Jun 2016 14:24:54 GMT Gysbert_Wassenaar 2016-06-07T14:24:54Z Bar Graph with two measures from different tables https://community.qlik.com/t5/App-Development/Bar-Graph-with-two-measures-from-different-tables/m-p/1142121#M20261 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Hi All,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I am new to QlikSense and I am just getting a hang of getting things done here.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">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. </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Please help...</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Milan</P></BODY></HTML> Sat, 16 Nov 2024 10:35:50 GMT https://community.qlik.com/t5/App-Development/Bar-Graph-with-two-measures-from-different-tables/m-p/1142121#M20261 2024-11-16T10:35:50Z Re: Bar Graph with two measures from different tables https://community.qlik.com/t5/App-Development/Bar-Graph-with-two-measures-from-different-tables/m-p/1142122#M20262 <HTML><HEAD></HEAD><BODY><P>It depends on how the two tables are linked. But in principle it's no problem to create measures using fields from different tables.</P></BODY></HTML> Tue, 07 Jun 2016 14:24:54 GMT https://community.qlik.com/t5/App-Development/Bar-Graph-with-two-measures-from-different-tables/m-p/1142122#M20262 Gysbert_Wassenaar 2016-06-07T14:24:54Z Re: Bar Graph with two measures from different tables https://community.qlik.com/t5/App-Development/Bar-Graph-with-two-measures-from-different-tables/m-p/1142123#M20263 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Wed, 06 Jul 2016 06:20:06 GMT https://community.qlik.com/t5/App-Development/Bar-Graph-with-two-measures-from-different-tables/m-p/1142123#M20263 2016-07-06T06:20:06Z