topic Re: bar chart with 2 dimensions and 2 formulas in QlikView https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687327#M1064535 <HTML><HEAD></HEAD><BODY><P>True, thank you. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 30 Sep 2014 11:23:03 GMT 2014-09-30T11:23:03Z bar chart with 2 dimensions and 2 formulas https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687319#M1064527 <HTML><HEAD></HEAD><BODY><P>Hello everyone</P><P></P><P>Is it possible to create a bar chart with 2 dimensions, say business unit and year and compare the sum of the earnings from the current and the last year?</P><P></P><P>When I try to create this chart the two sums are stacked. I am not able to separate the two sums. They remain stacked in the same bar...</P><P></P><P>Thank you for your help!</P><P></P><P>Jan</P></BODY></HTML> Wed, 24 Sep 2014 17:51:58 GMT https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687319#M1064527 2014-09-24T17:51:58Z Re: bar chart with 2 dimensions and 2 formulas https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687320#M1064528 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Could you post a sample if possible??</P><P></P><P>Kiru</P></BODY></HTML> Wed, 24 Sep 2014 17:54:11 GMT https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687320#M1064528 2014-09-24T17:54:11Z Re: bar chart with 2 dimensions and 2 formulas https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687321#M1064529 <HTML><HEAD></HEAD><BODY><P>Hi Kiru</P><P>maybe these screeshots help to explain:</P><P><IMG alt="Screen shot 2014-09-24 at 7.57.13 PM.png" class="jive-image" src="/legacyfs/online/67561_Screen shot 2014-09-24 at 7.57.13 PM.png" /><IMG alt="Screen shot 2014-09-24 at 7.56.53 PM.png" class="jive-image" src="/legacyfs/online/67586_Screen shot 2014-09-24 at 7.56.53 PM.png" style="width: 620px; height: 466px;" /></P><P><IMG alt="Screen shot 2014-09-24 at 7.57.06 PM.png" class="jive-image" src="/legacyfs/online/67587_Screen shot 2014-09-24 at 7.57.06 PM.png" style="width: 620px; height: 465px;" /></P></BODY></HTML> Wed, 24 Sep 2014 17:59:06 GMT https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687321#M1064529 2014-09-24T17:59:06Z Re: bar chart with 2 dimensions and 2 formulas https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687322#M1064530 <HTML><HEAD></HEAD><BODY><P>If I understood your problem correctly, I have done a sample example, please have a look at it.</P><P></P><P>Let me know if I am wrong.</P><P></P><P>Kiru</P></BODY></HTML> Wed, 24 Sep 2014 18:30:57 GMT https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687322#M1064530 2014-09-24T18:30:57Z Re: bar chart with 2 dimensions and 2 formulas https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687323#M1064531 <HTML><HEAD></HEAD><BODY><P>Justo go to Properties of the chart, select STYLE, and then in SUBTYPE select GROUPED.</P><P></P><P>Like this:<IMG alt="HELP.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/67592_HELP.png" style="width: 620px; height: 449px;" /></P></BODY></HTML> Wed, 24 Sep 2014 18:47:42 GMT https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687323#M1064531 2014-09-24T18:47:42Z Re: bar chart with 2 dimensions and 2 formulas https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687324#M1064532 <HTML><HEAD></HEAD><BODY><P>Hi Ramiro</P><P></P><P>Weired thing is, "grouped" is selected...</P><P></P><P>Best</P><P></P><P>Jan</P></BODY></HTML> Wed, 24 Sep 2014 20:02:27 GMT https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687324#M1064532 2014-09-24T20:02:27Z Re: bar chart with 2 dimensions and 2 formulas https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687325#M1064533 <HTML><HEAD></HEAD><BODY><P>Ok, i've solved you problem <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Go to the dimentions tab, "edit groups", create a new "drill-down-group" with the dimentions of the chart. Delete the dimentions and add the group as the only dimention.</P><P></P><P>It should work!</P><P></P><P>Editing with images in german:<BR /><IMG alt="HELP1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/67594_HELP1.png" style="width: 620px; height: 472px;" /></P><P></P><P></P><P><IMG alt="HELP2.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/67598_HELP2.png" style="width: 620px; height: 484px;" /></P></BODY></HTML> Wed, 24 Sep 2014 20:30:11 GMT https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687325#M1064533 2014-09-24T20:30:11Z Re: bar chart with 2 dimensions and 2 formulas https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687326#M1064534 <HTML><HEAD></HEAD><BODY><P>Hallo Jan,</P><P></P><P>one possible solution might be:</P><P></P><P><IMG alt="QlikCommunity_Thread_134847_Pic1.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/67604_QlikCommunity_Thread_134847_Pic1.JPG.jpg" style="width: 620px; height: 316px;" /></P><P></P><P>hope this helps</P><P></P><P>Gruß</P><P></P><P>Marco</P></BODY></HTML> Wed, 24 Sep 2014 22:39:09 GMT https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687326#M1064534 MarcoWedel 2014-09-24T22:39:09Z Re: bar chart with 2 dimensions and 2 formulas https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687327#M1064535 <HTML><HEAD></HEAD><BODY><P>True, thank you. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 30 Sep 2014 11:23:03 GMT https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687327#M1064535 2014-09-30T11:23:03Z Re: bar chart with 2 dimensions and 2 formulas https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687328#M1064536 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>please mark this thread answered, if there are no further questions.</P><P></P><P>thanks</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Tue, 30 Sep 2014 14:51:57 GMT https://community.qlik.com/t5/QlikView/bar-chart-with-2-dimensions-and-2-formulas/m-p/687328#M1064536 MarcoWedel 2014-09-30T14:51:57Z