How do I make this chart in QlikView

[#1]

Hey Guys,

Im a little stuck. I'm trying to build this chart in QlikView but I can't seem to get it to work.

I hope someone can help me out.

Enclosed is an Excel sheet of what I'm trying to accomplish.

You will find 4 blue columns:
ID = productID
GROUP = productGroup
TOTAL_PRICE = total net price of products in stock
QTY = Quantity of products in stock

Followed by 3 red columns (these are the ones I'm trying to calculate in QlikView)
UNIT_PRICE = Unit price
TOTAL_PRICE_SHARE = % of total net price of products compared to the total sum of the productgroup
CUMMULATED_SHARE = previous - 100%

I hope somebody can help me out.

Grtz,

/Sajjad

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0602.QV_5F00_Problem1.xlsx:550:0]

[Anonymous]

do you have the file in .xls format too?

[#3]

Here you go Adrian,

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0876.QV_5F00_Problem1.xls:550:0]

Thanks 🙂

[#4]

Hi,

view attached file.

Alex

[#5]

Hey Alex,

Thanks for your solution, this has helped me out alot.

But quick question, I've made a small mistake in my excel-sheet I posted yesterday.

If you look at the last column you will understand.

The column cumulated share looks at the group column and then does the subtraction.

enclosed you'll find the excel sheet.

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/4062.QV_5F00_Problem1.xls:550:0]

Thanks alot 🙂

[#6]

in attached file there's another solution.

note:
1) the graph is a pivot with only 2 dimensions
2) GROUP is the first dimension
2) TOTAL_PRICE and QTY are expressions