topic Making a graph on 3 dimensions in QlikView https://community.qlik.com/t5/QlikView/Making-a-graph-on-3-dimensions/m-p/386074#M144194 <HTML><HEAD></HEAD><BODY><P>Hi, i could use a bit of help trying to make a graph that shows how a configuration that sells for diffrent prices in diffrent locations affects the revenue example:</P><P></P><P>Store 1 Sells Addidas pants for 10$ and sells a total of 100 pants</P><P>Store 1 Sells Addidas pants with stripes for 10$ and sells a total of 100 pants</P><P></P><P>store 2 sells addidas pants for 15$ and sells a total of 30 pants</P><P><SPAN style="font-size: 10pt;">store 2 sells addidas pants with stripes for 12$ and sells a total of 30 pants</SPAN></P><P></P><P>store 3 Sells addidas pants for 9$ and sells 10 pants</P><P>store 3 Sells addidas pants with stripes for 4$ and sells 10 pants</P><P></P><P>store 4 sells addidas pants stripes for 11$ and sells 9 pants</P><P>store 4 sells addidas pants with stripes for 19$ and sells 9 pants</P><P>and so on</P><P></P><P>i want to see on the graph how manny % of for example Addidas pants in all stores (eventhou they sell for diffrent prices) how manny % they are of total sell</P><P></P><P>the dimensions i have are following</P><P></P><P>Panttypes ( Addidas pants and Addidas pants with stripes)</P><P>Stores </P><P>Retail price ( prices of each type of pant)</P><P></P><P>i made this: num(sum([panttypes])/sum(total [Retail Price]), '##,##0%')&nbsp; it shows all items sold in 1 store and how that store affects total revenue if i choose all stores.</P><P></P><P>Please help</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 20 May 2013 12:29:41 GMT 2013-05-20T12:29:41Z Making a graph on 3 dimensions https://community.qlik.com/t5/QlikView/Making-a-graph-on-3-dimensions/m-p/386074#M144194 <HTML><HEAD></HEAD><BODY><P>Hi, i could use a bit of help trying to make a graph that shows how a configuration that sells for diffrent prices in diffrent locations affects the revenue example:</P><P></P><P>Store 1 Sells Addidas pants for 10$ and sells a total of 100 pants</P><P>Store 1 Sells Addidas pants with stripes for 10$ and sells a total of 100 pants</P><P></P><P>store 2 sells addidas pants for 15$ and sells a total of 30 pants</P><P><SPAN style="font-size: 10pt;">store 2 sells addidas pants with stripes for 12$ and sells a total of 30 pants</SPAN></P><P></P><P>store 3 Sells addidas pants for 9$ and sells 10 pants</P><P>store 3 Sells addidas pants with stripes for 4$ and sells 10 pants</P><P></P><P>store 4 sells addidas pants stripes for 11$ and sells 9 pants</P><P>store 4 sells addidas pants with stripes for 19$ and sells 9 pants</P><P>and so on</P><P></P><P>i want to see on the graph how manny % of for example Addidas pants in all stores (eventhou they sell for diffrent prices) how manny % they are of total sell</P><P></P><P>the dimensions i have are following</P><P></P><P>Panttypes ( Addidas pants and Addidas pants with stripes)</P><P>Stores </P><P>Retail price ( prices of each type of pant)</P><P></P><P>i made this: num(sum([panttypes])/sum(total [Retail Price]), '##,##0%')&nbsp; it shows all items sold in 1 store and how that store affects total revenue if i choose all stores.</P><P></P><P>Please help</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 20 May 2013 12:29:41 GMT https://community.qlik.com/t5/QlikView/Making-a-graph-on-3-dimensions/m-p/386074#M144194 2013-05-20T12:29:41Z