topic Histogram with multiple dimensions and expressions in QlikView https://community.qlik.com/t5/QlikView/Histogram-with-multiple-dimensions-and-expressions/m-p/1430355#M430340 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>i need to display a histogram with 3 expressions( Sales, Budget,sales N-1)&nbsp; and 2 dimensions (Year , Product) like this:</P><P>the dimension Year in the axis X but the product (EMN,EDT,SOD,PRF) on the bar. and the expressions are on different bar, how can i do this ??</P><P><IMG alt="qlik.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/180858_qlik.png" style="height: auto;" />Be</P><P>because when i ve tried to do it in qlikview the result i get is this : both of the dimension are on the axis X, and the expressions are on the same bar</P><P><IMG alt="qlik2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/180859_qlik2.png" style="height: auto;" /></P></BODY></HTML> Wed, 25 Oct 2017 11:55:12 GMT Anonymous 2017-10-25T11:55:12Z Histogram with multiple dimensions and expressions https://community.qlik.com/t5/QlikView/Histogram-with-multiple-dimensions-and-expressions/m-p/1430355#M430340 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>i need to display a histogram with 3 expressions( Sales, Budget,sales N-1)&nbsp; and 2 dimensions (Year , Product) like this:</P><P>the dimension Year in the axis X but the product (EMN,EDT,SOD,PRF) on the bar. and the expressions are on different bar, how can i do this ??</P><P><IMG alt="qlik.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/180858_qlik.png" style="height: auto;" />Be</P><P>because when i ve tried to do it in qlikview the result i get is this : both of the dimension are on the axis X, and the expressions are on the same bar</P><P><IMG alt="qlik2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/180859_qlik2.png" style="height: auto;" /></P></BODY></HTML> Wed, 25 Oct 2017 11:55:12 GMT https://community.qlik.com/t5/QlikView/Histogram-with-multiple-dimensions-and-expressions/m-p/1430355#M430340 Anonymous 2017-10-25T11:55:12Z Re: Histogram with multiple dimensions and expressions https://community.qlik.com/t5/QlikView/Histogram-with-multiple-dimensions-and-expressions/m-p/1430356#M430341 <HTML><HEAD></HEAD><BODY><P>any help please?</P></BODY></HTML> Mon, 30 Oct 2017 10:12:21 GMT https://community.qlik.com/t5/QlikView/Histogram-with-multiple-dimensions-and-expressions/m-p/1430356#M430341 Anonymous 2017-10-30T10:12:21Z Re: Histogram with multiple dimensions and expressions https://community.qlik.com/t5/QlikView/Histogram-with-multiple-dimensions-and-expressions/m-p/1430357#M430342 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>On the "Style" tab in the chart properties, you must select SubType -&gt; Stacked.</P></BODY></HTML> Mon, 30 Oct 2017 13:12:52 GMT https://community.qlik.com/t5/QlikView/Histogram-with-multiple-dimensions-and-expressions/m-p/1430357#M430342 sharpjoki 2017-10-30T13:12:52Z Re: Histogram with multiple dimensions and expressions https://community.qlik.com/t5/QlikView/Histogram-with-multiple-dimensions-and-expressions/m-p/1430358#M430343 <HTML><HEAD></HEAD><BODY><P>thank you for your answer, I have already&nbsp; test that option but there is no change i have the same result as the second image posted.</P><P></P><P>Any other suggestions please?</P></BODY></HTML> Mon, 30 Oct 2017 13:54:58 GMT https://community.qlik.com/t5/QlikView/Histogram-with-multiple-dimensions-and-expressions/m-p/1430358#M430343 Anonymous 2017-10-30T13:54:58Z Re: Histogram with multiple dimensions and expressions https://community.qlik.com/t5/QlikView/Histogram-with-multiple-dimensions-and-expressions/m-p/1430359#M430344 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Attach please qvw with the chart.</SPAN></P></BODY></HTML> Mon, 30 Oct 2017 22:02:05 GMT https://community.qlik.com/t5/QlikView/Histogram-with-multiple-dimensions-and-expressions/m-p/1430359#M430344 sharpjoki 2017-10-30T22:02:05Z Re: Histogram with multiple dimensions and expressions https://community.qlik.com/t5/QlikView/Histogram-with-multiple-dimensions-and-expressions/m-p/1430360#M430345 <HTML><HEAD></HEAD><BODY><P>thank you for your answer , but i really can't share the qvw , the data is so confidential.</P><P>i have capture all the parameters hope its clear </P><P>thank you</P><P>t<IMG alt="qlik5.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/181610_qlik5.png" style="height: 451px; width: 620px;" /></P><P><IMG alt="qlik6.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/181611_qlik6.png" style="height: 446px; width: 620px;" /><IMG alt="qlik7.png" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/181612_qlik7.png" style="height: 445px; width: 620px;" /><IMG alt="qlik8.png" class="image-4 jive-image" src="https://community.qlik.com/legacyfs/online/181613_qlik8.png" style="height: 450px; width: 620px;" /></P></BODY></HTML> Tue, 31 Oct 2017 12:16:40 GMT https://community.qlik.com/t5/QlikView/Histogram-with-multiple-dimensions-and-expressions/m-p/1430360#M430345 Anonymous 2017-10-31T12:16:40Z Re: Histogram with multiple dimensions and expressions https://community.qlik.com/t5/QlikView/Histogram-with-multiple-dimensions-and-expressions/m-p/1430361#M430346 <HTML><HEAD></HEAD><BODY><P>Sorry, <SPAN lang="en">I confused</SPAN>, on <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">the "Style" tab in the chart properties, you must select Sous-Type-&gt; Groupe.</SPAN></P></BODY></HTML> Tue, 31 Oct 2017 13:06:26 GMT https://community.qlik.com/t5/QlikView/Histogram-with-multiple-dimensions-and-expressions/m-p/1430361#M430346 sharpjoki 2017-10-31T13:06:26Z Re: Histogram with multiple dimensions and expressions https://community.qlik.com/t5/QlikView/Histogram-with-multiple-dimensions-and-expressions/m-p/1430362#M430347 <HTML><HEAD></HEAD><BODY><P>Thank you but when i select "groupe" as "sous type", it gives this:<IMG alt="qlik9.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/181638_qlik9.png" style="height: auto;" /></P><P>its not the structure&nbsp; that i want, here is the result i want : the different KPI on X axis , and the dimension on the bar with different colors</P><P><IMG alt="qlik.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/181639_qlik.png" style="height: auto;" /></P></BODY></HTML> Tue, 31 Oct 2017 14:16:42 GMT https://community.qlik.com/t5/QlikView/Histogram-with-multiple-dimensions-and-expressions/m-p/1430362#M430347 Anonymous 2017-10-31T14:16:42Z