topic Re: bar chart with three dimesions in App Development https://community.qlik.com/t5/App-Development/bar-chart-with-three-dimesions/m-p/1565356#M41173 <P>If you are using Qlikview :&nbsp;<A href="https://community.qlik.com/t5/QlikView-App-Development/stacked-and-grouped-barchart-in-qlikview/td-p/22429" target="_self">Stacked &amp; Grouped Bar chart</A></P><P>If you are using Qliksense: Try combo chart &amp; select Bar from properties for all the three values.</P><P>&nbsp;</P><P>If you want to show the trend using line chart. Go to properties and change it to Narrow/Wide or use fixed values to represent.</P> Thu, 04 Apr 2019 17:26:07 GMT santho_ak 2019-04-04T17:26:07Z bar chart with three dimesions https://community.qlik.com/t5/App-Development/bar-chart-with-three-dimesions/m-p/1564992#M41142 <P>Hello everyone,<BR />I have the following data set:</P><TABLE><TBODY><TR><TD>Weeks</TD><TD>Sales</TD><TD>Hours</TD><TD>Productivity</TD></TR><TR><TD>01/01/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.420.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.400.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 167,42&nbsp;&nbsp;</TD></TR><TR><TD>08/01/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.410.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.400.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 167,05&nbsp;&nbsp;</TD></TR><TR><TD>15/01/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.405.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.400.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 166,86&nbsp;&nbsp;</TD></TR><TR><TD>22/01/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.400.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.400.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 166,67&nbsp;&nbsp;</TD></TR><TR><TD>29/01/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.395.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.400.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 166,48&nbsp;&nbsp;</TD></TR><TR><TD>05/02/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.390.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.400.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 166,29&nbsp;&nbsp;</TD></TR><TR><TD>12/02/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.390.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.400.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 166,29&nbsp;&nbsp;</TD></TR><TR><TD>19/02/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.390.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.400.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 166,29&nbsp;&nbsp;</TD></TR><TR><TD>26/02/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.385.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.400.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 166,10&nbsp;&nbsp;</TD></TR><TR><TD>05/03/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.380.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.400.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 165,91&nbsp;&nbsp;</TD></TR><TR><TD>12/03/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.385.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.400.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 166,10&nbsp;&nbsp;</TD></TR><TR><TD>19/03/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.390.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.400.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 166,29&nbsp;&nbsp;</TD></TR><TR><TD>26/03/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.400.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.400.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 166,67&nbsp;&nbsp;</TD></TR><TR><TD>02/04/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.380.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.350.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 166,22&nbsp;&nbsp;</TD></TR><TR><TD>09/04/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.360.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.300.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 165,78&nbsp;&nbsp;</TD></TR><TR><TD>16/04/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.360.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.400.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 165,15&nbsp;&nbsp;</TD></TR><TR><TD>23/04/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.355.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.400.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 164,96&nbsp;&nbsp;</TD></TR><TR><TD>30/04/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.355.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.400.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 164,96&nbsp;&nbsp;</TD></TR><TR><TD>07/05/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.360.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.400.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 165,15&nbsp;&nbsp;</TD></TR><TR><TD>14/05/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.355.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.400.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 164,96&nbsp;&nbsp;</TD></TR><TR><TD>21/05/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.355.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.400.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 164,96&nbsp;&nbsp;</TD></TR><TR><TD>28/05/2018</TD><TD>&nbsp;&nbsp;&nbsp; 4.350.000.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp; 26.400.000,00&nbsp;&nbsp;</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 164,77&nbsp;&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I would like to represent the trend in graphic form using a single chart.&nbsp;The problem is that the three values are very different from each other. I tried to use two Y axis, one with sales and hours and the other with productivity, but the result does not satisfy me.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Cattura.PNG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/9444i9FC79ECEC8E37A02/image-size/medium?v=v2&amp;px=400" role="button" title="Cattura.PNG" alt="Cattura.PNG" /></span></P><P>Is there a way to get the trend of all three measures clearly?</P><P>Sort of like this:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Cattura 2.PNG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/9446iE241194361271855/image-size/medium?v=v2&amp;px=400" role="button" title="Cattura 2.PNG" alt="Cattura 2.PNG" /></span></P><P>Thanks to everyone who can help.</P> Sat, 16 Nov 2024 06:09:28 GMT https://community.qlik.com/t5/App-Development/bar-chart-with-three-dimesions/m-p/1564992#M41142 luca_bellotti 2024-11-16T06:09:28Z Re: bar chart with three dimesions https://community.qlik.com/t5/App-Development/bar-chart-with-three-dimesions/m-p/1565356#M41173 <P>If you are using Qlikview :&nbsp;<A href="https://community.qlik.com/t5/QlikView-App-Development/stacked-and-grouped-barchart-in-qlikview/td-p/22429" target="_self">Stacked &amp; Grouped Bar chart</A></P><P>If you are using Qliksense: Try combo chart &amp; select Bar from properties for all the three values.</P><P>&nbsp;</P><P>If you want to show the trend using line chart. Go to properties and change it to Narrow/Wide or use fixed values to represent.</P> Thu, 04 Apr 2019 17:26:07 GMT https://community.qlik.com/t5/App-Development/bar-chart-with-three-dimesions/m-p/1565356#M41173 santho_ak 2019-04-04T17:26:07Z