topic Re: Re: Bar chart with grouped bars behind each other in QlikView https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659634#M240618 <HTML><HEAD></HEAD><BODY><P>Hi Alec,</P><P></P><P>Please check attached file for solution.&nbsp; Hope it helps you.</P><P></P><P>Regards,</P><P>jagan.</P></BODY></HTML> Tue, 21 Oct 2014 05:49:03 GMT jagan 2014-10-21T05:49:03Z Bar chart with grouped bars behind each other https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659625#M240609 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I am trying to replicate the chart in my excel attachment with no luck..</P><P></P><P>Can you please help me..</P><P></P><P>Best,</P><P>Alec</P></BODY></HTML> Mon, 20 Oct 2014 07:05:00 GMT https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659625#M240609 alec1982 2014-10-20T07:05:00Z Re: Bar chart with grouped bars behind each other https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659626#M240610 <HTML><HEAD></HEAD><BODY><P>Bar chart-&gt; Style tab: last 'Look'.</P></BODY></HTML> Mon, 20 Oct 2014 07:08:30 GMT https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659626#M240610 tresB 2014-10-20T07:08:30Z Re: Bar chart with grouped bars behind each other https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659627#M240611 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thank you for the quick reply but that doesn't work. see attached the qvw.</P></BODY></HTML> Mon, 20 Oct 2014 07:17:31 GMT https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659627#M240611 alec1982 2014-10-20T07:17:31Z Re: Bar chart with grouped bars behind each other https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659628#M240612 <HTML><HEAD></HEAD><BODY><P>It actually depends on number of dimensions/expressions you use in your chart.<IMG alt="Screen Shot 10-20-14 at 01.13 PM.PNG.png" class="jive-image" src="/legacyfs/online/69275_Screen Shot 10-20-14 at 01.13 PM.PNG.png" /></P></BODY></HTML> Mon, 20 Oct 2014 07:45:29 GMT https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659628#M240612 tresB 2014-10-20T07:45:29Z Re: Bar chart with grouped bars behind each other https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659629#M240613 <HTML><HEAD></HEAD><BODY><P>Thank you again for the information but that doesn't help me.. </P></BODY></HTML> Mon, 20 Oct 2014 13:17:09 GMT https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659629#M240613 alec1982 2014-10-20T13:17:09Z Re: Bar chart with grouped bars behind each other https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659630#M240614 <HTML><HEAD></HEAD><BODY><P>I am still not able to find a solution to replicate the chart I have attached on my post..and would appreciate any help or suggestion.</P></BODY></HTML> Tue, 21 Oct 2014 01:15:09 GMT https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659630#M240614 alec1982 2014-10-21T01:15:09Z Re: Re: Bar chart with grouped bars behind each other https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659631#M240615 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I think this chart is not possible in Qlikview, the best chart for this is the Line chart you can see the flow of the values clearly.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 21 Oct 2014 02:46:20 GMT https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659631#M240615 jagan 2014-10-21T02:46:20Z Re: Bar chart with grouped bars behind each other https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659632#M240616 <HTML><HEAD></HEAD><BODY><P>Hi Alec</P><P></P><P>you need to restructure your data.</P><P>Please see screenshot &amp; check attached qvw-file.</P><P><IMG __jive_id="69356" alt="Bar chart.PNG.png" class="jive-image" height="234" src="/legacyfs/online/69356_Bar chart.PNG.png" style="width: 321.904761904762px; height: 234px;" width="322" /></P><P>Let me know when you have questions.</P><P></P><P>Best regards,</P><P>Ronny</P><P></P><P>PS: Maybe you can use File Wizard (Transform) to restructure the data.</P></BODY></HTML> Tue, 21 Oct 2014 04:20:30 GMT https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659632#M240616 r_wroblewski 2014-10-21T04:20:30Z Re: Bar chart with grouped bars behind each other https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659633#M240617 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thank you for your help.. this works if I can modify my data but I cannot, the expressions to calculate PY Mar, PY Rev and PY Quota have set analysis in them and I am afraid I will not be able to change the structure..</P><P></P><P>Any thoughts?</P><P></P><P>best,</P><P>Alec</P></BODY></HTML> Tue, 21 Oct 2014 04:44:40 GMT https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659633#M240617 alec1982 2014-10-21T04:44:40Z Re: Re: Bar chart with grouped bars behind each other https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659634#M240618 <HTML><HEAD></HEAD><BODY><P>Hi Alec,</P><P></P><P>Please check attached file for solution.&nbsp; Hope it helps you.</P><P></P><P>Regards,</P><P>jagan.</P></BODY></HTML> Tue, 21 Oct 2014 05:49:03 GMT https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659634#M240618 jagan 2014-10-21T05:49:03Z Re: Bar chart with grouped bars behind each other https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659635#M240619 <HTML><HEAD></HEAD><BODY><P><SPAN><SPAN>Hi Alec</SPAN></SPAN></P><P></P><P>You can try out Jagans proposal.</P><P>Another possibility could be the usage of a dynamic dimension in conjunction with variables for different formulas.</P><P></P><P>Regards,</P><P>Ronny </P></BODY></HTML> Tue, 21 Oct 2014 07:50:51 GMT https://community.qlik.com/t5/QlikView/Bar-chart-with-grouped-bars-behind-each-other/m-p/659635#M240619 r_wroblewski 2014-10-21T07:50:51Z