topic Re: How to create 100% stacked columns with absolute number in QlikView https://community.qlik.com/t5/QlikView/How-to-create-100-stacked-columns-with-absolute-number/m-p/1073700#M525804 <HTML><HEAD></HEAD><BODY><P>May be make use of Dual() function. Something like this:</P><P></P><P><STRONG>Dual(Sum(Field), Sum(Field), Sum(Total &lt;Year&gt; Field))</STRONG></P><P></P><P>May be share a sample for more help.</P></BODY></HTML> Tue, 26 Jan 2016 14:00:20 GMT sunny_talwar 2016-01-26T14:00:20Z How to create 100% stacked columns with absolute number https://community.qlik.com/t5/QlikView/How-to-create-100-stacked-columns-with-absolute-number/m-p/1073699#M525803 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P>I need to create the chart as shown: columns have the same height, but they show different values segmented by Groups. Is it possible?</P><P>Id est, I would like to replace the percentage with the absolute values, keeping the proportion of the percentage.</P><P></P><P><IMG alt="Example.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/112557_Example.png" style="height: auto;" /> </P><P></P><P>Thanks!</P><P>Elena</P></BODY></HTML> Tue, 26 Jan 2016 13:58:32 GMT https://community.qlik.com/t5/QlikView/How-to-create-100-stacked-columns-with-absolute-number/m-p/1073699#M525803 Anonymous 2016-01-26T13:58:32Z Re: How to create 100% stacked columns with absolute number https://community.qlik.com/t5/QlikView/How-to-create-100-stacked-columns-with-absolute-number/m-p/1073700#M525804 <HTML><HEAD></HEAD><BODY><P>May be make use of Dual() function. Something like this:</P><P></P><P><STRONG>Dual(Sum(Field), Sum(Field), Sum(Total &lt;Year&gt; Field))</STRONG></P><P></P><P>May be share a sample for more help.</P></BODY></HTML> Tue, 26 Jan 2016 14:00:20 GMT https://community.qlik.com/t5/QlikView/How-to-create-100-stacked-columns-with-absolute-number/m-p/1073700#M525804 sunny_talwar 2016-01-26T14:00:20Z Re: How to create 100% stacked columns with absolute number https://community.qlik.com/t5/QlikView/How-to-create-100-stacked-columns-with-absolute-number/m-p/1073701#M525805 <HTML><HEAD></HEAD><BODY><P>Thank you, but I think it doesn't work...</P><P></P><P>I attched example files.</P><P></P><P>Thanks!</P><P>Elena</P></BODY></HTML> Tue, 26 Jan 2016 14:25:57 GMT https://community.qlik.com/t5/QlikView/How-to-create-100-stacked-columns-with-absolute-number/m-p/1073701#M525805 Anonymous 2016-01-26T14:25:57Z Re: How to create 100% stacked columns with absolute number https://community.qlik.com/t5/QlikView/How-to-create-100-stacked-columns-with-absolute-number/m-p/1073702#M525806 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/112564_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 26 Jan 2016 14:27:31 GMT https://community.qlik.com/t5/QlikView/How-to-create-100-stacked-columns-with-absolute-number/m-p/1073702#M525806 sunny_talwar 2016-01-26T14:27:31Z Re: How to create 100% stacked columns with absolute number https://community.qlik.com/t5/QlikView/How-to-create-100-stacked-columns-with-absolute-number/m-p/1073703#M525807 <HTML><HEAD></HEAD><BODY><P>Yes, thanks, you are very kind!</P><P></P><P>Elena</P></BODY></HTML> Tue, 26 Jan 2016 14:52:03 GMT https://community.qlik.com/t5/QlikView/How-to-create-100-stacked-columns-with-absolute-number/m-p/1073703#M525807 Anonymous 2016-01-26T14:52:03Z