topic Barchart 2 bars by type in QlikView https://community.qlik.com/t5/QlikView/Barchart-2-bars-by-type/m-p/1216970#M389655 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I would like to have 2 bars per month collored by type like in the picture.</P><P>One with the planned hours and 1 with the effective hours.</P><P>is this possible?</P><P>regards,</P><P>Kris</P><P></P><P><IMG alt="barchart.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/148833_barchart.JPG" style="height: auto;" /></P></BODY></HTML> Mon, 09 Jan 2017 15:50:42 GMT kris_vliegen 2017-01-09T15:50:42Z Barchart 2 bars by type https://community.qlik.com/t5/QlikView/Barchart-2-bars-by-type/m-p/1216970#M389655 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I would like to have 2 bars per month collored by type like in the picture.</P><P>One with the planned hours and 1 with the effective hours.</P><P>is this possible?</P><P>regards,</P><P>Kris</P><P></P><P><IMG alt="barchart.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/148833_barchart.JPG" style="height: auto;" /></P></BODY></HTML> Mon, 09 Jan 2017 15:50:42 GMT https://community.qlik.com/t5/QlikView/Barchart-2-bars-by-type/m-p/1216970#M389655 kris_vliegen 2017-01-09T15:50:42Z Re: Barchart 2 bars by type https://community.qlik.com/t5/QlikView/Barchart-2-bars-by-type/m-p/1216971#M389656 <HTML><HEAD></HEAD><BODY><P>try</P><P>In a stacked bar chart,</P><P>make Dimension 1 = Month</P><P>Dimension 2 : calculated dim = if ( Field to find Planed, effective, 'Planned', 'effective')</P><P>Dimension 3: Type</P><P>Measure : count( hours)</P></BODY></HTML> Mon, 09 Jan 2017 16:04:03 GMT https://community.qlik.com/t5/QlikView/Barchart-2-bars-by-type/m-p/1216971#M389656 girirajsinh 2017-01-09T16:04:03Z