topic Combined chart as stacked columns in QlikView https://community.qlik.com/t5/QlikView/Combined-chart-as-stacked-columns/m-p/723367#M474204 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">first</SPAN> <SPAN class="hps">I</SPAN> <SPAN class="hps">want to apologize</SPAN> <SPAN class="hps">for</SPAN> <SPAN class="hps">my</SPAN> <SPAN class="hps">English</SPAN><SPAN>,</SPAN> <SPAN class="hps">I use the</SPAN> <SPAN class="hps">google</SPAN> <SPAN class="hps">translator</SPAN><SPAN>.</SPAN> </P><P></P><P><SPAN class="hps">now</SPAN> <SPAN class="hps">my</SPAN> <SPAN class="hps">question about</SPAN><SPAN>,</SPAN> <SPAN class="hps">like to</SPAN> <SPAN class="hps">create a chart</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="hps">two dimensions</SPAN><SPAN>.</SPAN> <SPAN class="hps">The first dimension</SPAN> <SPAN class="hps">are</SPAN> <SPAN class="hps">months</SPAN><SPAN>,</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">second</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">projects</SPAN><SPAN>.</SPAN> <SPAN class="hps">As a</SPAN> <SPAN class="hps">type of chart</SPAN> <SPAN class="hps">I want to</SPAN> <SPAN class="hps">display</SPAN> <SPAN class="hps">columns and</SPAN> <SPAN class="hps">lines (Kombi-Diagramm)</SPAN><SPAN>.</SPAN> <SPAN class="hps">The sum of the</SPAN> <SPAN class="hps">time </SPAN><SPAN class="hps">for each project</SPAN> <SPAN class="hps">to be displayed</SPAN> <SPAN class="hps">stacked in columns</SPAN><SPAN>,</SPAN> <SPAN class="hps">the sum of the</SPAN> <SPAN class="hps">capacity</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">plant</SPAN> <SPAN class="hps">per</SPAN> <SPAN class="hps">month</SPAN> <SPAN class="hps">in</SPAN> <SPAN class="hps">lines</SPAN><SPAN>.</SPAN> </P><P></P><P><SPAN class="hps">But as soon as</SPAN> <SPAN class="hps">I insert</SPAN> <SPAN class="hps">two</SPAN> <SPAN class="hps">formulas</SPAN><SPAN>,</SPAN> <SPAN class="hps">Qlikview</SPAN> <SPAN class="hps">makes the</SPAN> <SPAN class="hps">stacked column</SPAN> <SPAN class="hps">a grouped</SPAN> <SPAN class="hps">column and</SPAN> <SPAN class="hps">all</SPAN> <SPAN class="hps">values</SPAN> <SPAN class="hps">​​are</SPAN> <SPAN class="hps">next to each other</SPAN> <SPAN class="hps">to see</SPAN><SPAN>.</SPAN> <SPAN class="hps">However, the</SPAN> <SPAN class="hps">only way</SPAN> <SPAN class="hps">would be</SPAN> <SPAN class="hps">to</SPAN> <SPAN class="hps">delete the</SPAN> <SPAN class="hps">projects</SPAN> <SPAN class="hps">from the dimension</SPAN><SPAN>,</SPAN> <SPAN class="hps">so</SPAN> <SPAN class="hps">I have</SPAN> <SPAN class="hps">only solid</SPAN> <SPAN class="hps">pillars</SPAN> <SPAN class="hps">and is unable to</SPAN> <SPAN class="hps">assign</SPAN> <SPAN class="hps">the projects</SPAN> <SPAN class="hps">clearly</SPAN><SPAN>.</SPAN> </P><P></P><P><SPAN class="hps">Since</SPAN> <SPAN class="hps">it</SPAN> <SPAN class="hps">would</SPAN> <SPAN class="hps">surely</SPAN> <SPAN class="hps">give</SPAN> <SPAN class="hps">a</SPAN> <SPAN class="hps">solution</SPAN> <SPAN class="hps">for this.</SPAN> </P><P></P><P><SPAN class="hps">Best</SPAN> <SPAN class="hps">thanks for</SPAN> <SPAN class="hps">your help</SPAN> <SPAN class="hps">in advance</SPAN> <SPAN class="hps">=</SPAN><SPAN>)</SPAN></P><P> </P><P> </P></BODY></HTML> Tue, 30 Sep 2014 07:16:15 GMT tiklabaq 2014-09-30T07:16:15Z Combined chart as stacked columns https://community.qlik.com/t5/QlikView/Combined-chart-as-stacked-columns/m-p/723367#M474204 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">first</SPAN> <SPAN class="hps">I</SPAN> <SPAN class="hps">want to apologize</SPAN> <SPAN class="hps">for</SPAN> <SPAN class="hps">my</SPAN> <SPAN class="hps">English</SPAN><SPAN>,</SPAN> <SPAN class="hps">I use the</SPAN> <SPAN class="hps">google</SPAN> <SPAN class="hps">translator</SPAN><SPAN>.</SPAN> </P><P></P><P><SPAN class="hps">now</SPAN> <SPAN class="hps">my</SPAN> <SPAN class="hps">question about</SPAN><SPAN>,</SPAN> <SPAN class="hps">like to</SPAN> <SPAN class="hps">create a chart</SPAN> <SPAN class="hps">with</SPAN> <SPAN class="hps">two dimensions</SPAN><SPAN>.</SPAN> <SPAN class="hps">The first dimension</SPAN> <SPAN class="hps">are</SPAN> <SPAN class="hps">months</SPAN><SPAN>,</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">second</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">projects</SPAN><SPAN>.</SPAN> <SPAN class="hps">As a</SPAN> <SPAN class="hps">type of chart</SPAN> <SPAN class="hps">I want to</SPAN> <SPAN class="hps">display</SPAN> <SPAN class="hps">columns and</SPAN> <SPAN class="hps">lines (Kombi-Diagramm)</SPAN><SPAN>.</SPAN> <SPAN class="hps">The sum of the</SPAN> <SPAN class="hps">time </SPAN><SPAN class="hps">for each project</SPAN> <SPAN class="hps">to be displayed</SPAN> <SPAN class="hps">stacked in columns</SPAN><SPAN>,</SPAN> <SPAN class="hps">the sum of the</SPAN> <SPAN class="hps">capacity</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">plant</SPAN> <SPAN class="hps">per</SPAN> <SPAN class="hps">month</SPAN> <SPAN class="hps">in</SPAN> <SPAN class="hps">lines</SPAN><SPAN>.</SPAN> </P><P></P><P><SPAN class="hps">But as soon as</SPAN> <SPAN class="hps">I insert</SPAN> <SPAN class="hps">two</SPAN> <SPAN class="hps">formulas</SPAN><SPAN>,</SPAN> <SPAN class="hps">Qlikview</SPAN> <SPAN class="hps">makes the</SPAN> <SPAN class="hps">stacked column</SPAN> <SPAN class="hps">a grouped</SPAN> <SPAN class="hps">column and</SPAN> <SPAN class="hps">all</SPAN> <SPAN class="hps">values</SPAN> <SPAN class="hps">​​are</SPAN> <SPAN class="hps">next to each other</SPAN> <SPAN class="hps">to see</SPAN><SPAN>.</SPAN> <SPAN class="hps">However, the</SPAN> <SPAN class="hps">only way</SPAN> <SPAN class="hps">would be</SPAN> <SPAN class="hps">to</SPAN> <SPAN class="hps">delete the</SPAN> <SPAN class="hps">projects</SPAN> <SPAN class="hps">from the dimension</SPAN><SPAN>,</SPAN> <SPAN class="hps">so</SPAN> <SPAN class="hps">I have</SPAN> <SPAN class="hps">only solid</SPAN> <SPAN class="hps">pillars</SPAN> <SPAN class="hps">and is unable to</SPAN> <SPAN class="hps">assign</SPAN> <SPAN class="hps">the projects</SPAN> <SPAN class="hps">clearly</SPAN><SPAN>.</SPAN> </P><P></P><P><SPAN class="hps">Since</SPAN> <SPAN class="hps">it</SPAN> <SPAN class="hps">would</SPAN> <SPAN class="hps">surely</SPAN> <SPAN class="hps">give</SPAN> <SPAN class="hps">a</SPAN> <SPAN class="hps">solution</SPAN> <SPAN class="hps">for this.</SPAN> </P><P></P><P><SPAN class="hps">Best</SPAN> <SPAN class="hps">thanks for</SPAN> <SPAN class="hps">your help</SPAN> <SPAN class="hps">in advance</SPAN> <SPAN class="hps">=</SPAN><SPAN>)</SPAN></P><P> </P><P> </P></BODY></HTML> Tue, 30 Sep 2014 07:16:15 GMT https://community.qlik.com/t5/QlikView/Combined-chart-as-stacked-columns/m-p/723367#M474204 tiklabaq 2014-09-30T07:16:15Z