Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I make this chart in QlikView

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]

5 Replies
adrian_costar
Contributor III
Contributor III

do you have the file in .xls format too?

Not applicable
Author

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 🙂

Not applicable
Author

Hi,

view attached file.

Alex

Not applicable
Author

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 🙂

Not applicable
Author

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