topic How do I make this chart in QlikView in QlikView https://community.qlik.com/t5/QlikView/How-do-I-make-this-chart-in-QlikView/m-p/183725#M48877 <HTML><HEAD></HEAD><BODY><P>Hey Guys,</P><P>Im a little stuck. I'm trying to build this chart in QlikView but I can't seem to get it to work.</P><P>I hope someone can help me out.</P><P></P><P>Enclosed is an Excel sheet of what I'm trying to accomplish.</P><P></P><P>You will find 4 blue columns:<BR />ID = productID<BR />GROUP = productGroup<BR />TOTAL_PRICE = total net price of products in stock<BR />QTY = Quantity of products in stock</P><P>Followed by 3 red columns (these are the ones I'm trying to calculate in QlikView)<BR />UNIT_PRICE = Unit price<BR />TOTAL_PRICE_SHARE = % of total net price of products compared to the total sum of the productgroup<BR />CUMMULATED_SHARE = previous - 100%</P><P></P><P>I hope somebody can help me out.</P><P>Grtz,</P><P>/Sajjad</P><P>[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0602.QV_5F00_Problem1.xlsx:550:0]</P></BODY></HTML> Thu, 10 Jun 2010 10:05:50 GMT 2010-06-10T10:05:50Z How do I make this chart in QlikView https://community.qlik.com/t5/QlikView/How-do-I-make-this-chart-in-QlikView/m-p/183725#M48877 <HTML><HEAD></HEAD><BODY><P>Hey Guys,</P><P>Im a little stuck. I'm trying to build this chart in QlikView but I can't seem to get it to work.</P><P>I hope someone can help me out.</P><P></P><P>Enclosed is an Excel sheet of what I'm trying to accomplish.</P><P></P><P>You will find 4 blue columns:<BR />ID = productID<BR />GROUP = productGroup<BR />TOTAL_PRICE = total net price of products in stock<BR />QTY = Quantity of products in stock</P><P>Followed by 3 red columns (these are the ones I'm trying to calculate in QlikView)<BR />UNIT_PRICE = Unit price<BR />TOTAL_PRICE_SHARE = % of total net price of products compared to the total sum of the productgroup<BR />CUMMULATED_SHARE = previous - 100%</P><P></P><P>I hope somebody can help me out.</P><P>Grtz,</P><P>/Sajjad</P><P>[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0602.QV_5F00_Problem1.xlsx:550:0]</P></BODY></HTML> Thu, 10 Jun 2010 10:05:50 GMT https://community.qlik.com/t5/QlikView/How-do-I-make-this-chart-in-QlikView/m-p/183725#M48877 2010-06-10T10:05:50Z How do I make this chart in QlikView https://community.qlik.com/t5/QlikView/How-do-I-make-this-chart-in-QlikView/m-p/183726#M48878 <HTML><HEAD></HEAD><BODY><P>do you have the file in .xls format too?</P></BODY></HTML> Thu, 10 Jun 2010 12:58:28 GMT https://community.qlik.com/t5/QlikView/How-do-I-make-this-chart-in-QlikView/m-p/183726#M48878 Anonymous 2010-06-10T12:58:28Z How do I make this chart in QlikView https://community.qlik.com/t5/QlikView/How-do-I-make-this-chart-in-QlikView/m-p/183727#M48879 <HTML><HEAD></HEAD><BODY><P>Here you go Adrian,</P><P></P><P>[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0876.QV_5F00_Problem1.xls:550:0]</P><P></P><P>Thanks <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Thu, 10 Jun 2010 15:45:46 GMT https://community.qlik.com/t5/QlikView/How-do-I-make-this-chart-in-QlikView/m-p/183727#M48879 2010-06-10T15:45:46Z How do I make this chart in QlikView https://community.qlik.com/t5/QlikView/How-do-I-make-this-chart-in-QlikView/m-p/183728#M48880 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>view attached file.</P><P>Alex</P></BODY></HTML> Thu, 10 Jun 2010 18:09:02 GMT https://community.qlik.com/t5/QlikView/How-do-I-make-this-chart-in-QlikView/m-p/183728#M48880 2010-06-10T18:09:02Z How do I make this chart in QlikView https://community.qlik.com/t5/QlikView/How-do-I-make-this-chart-in-QlikView/m-p/183729#M48881 <HTML><HEAD></HEAD><BODY><P>Hey Alex,</P><P></P><P>Thanks for your solution, this has helped me out alot.</P><P>But quick question, I've made a small mistake in my excel-sheet I posted yesterday.</P><P>If you look at the last column you will understand.</P><P>The column cumulated share looks at the group column and then does the subtraction.</P><P>enclosed you'll find the excel sheet.</P><P>[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/4062.QV_5F00_Problem1.xls:550:0]</P><P></P><P>Thanks alot <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Fri, 11 Jun 2010 09:52:03 GMT https://community.qlik.com/t5/QlikView/How-do-I-make-this-chart-in-QlikView/m-p/183729#M48881 2010-06-11T09:52:03Z How do I make this chart in QlikView https://community.qlik.com/t5/QlikView/How-do-I-make-this-chart-in-QlikView/m-p/183730#M48882 <HTML><HEAD></HEAD><BODY><P>in attached file there's another solution.</P><P><BR />note:<BR />1) the graph is a pivot with only 2 dimensions<BR />2) GROUP is the first dimension<BR />2) TOTAL_PRICE and QTY are expressions</P></BODY></HTML> Fri, 11 Jun 2010 13:16:33 GMT https://community.qlik.com/t5/QlikView/How-do-I-make-this-chart-in-QlikView/m-p/183730#M48882 2010-06-11T13:16:33Z