topic Re: Pie Chart graph filtered for Top 10 in QlikView

Pie Chart graph filtered for Top 10

stjernvd — Mon, 14 Dec 2015 14:43:37 GMT

Hi,

I have my pie chart that filters for top 10 according to revenue (sum(revenue) for a Product.

How do I make a pie chart that filters for two expressions?

So sum(revenue) and sum(orders) for Product (dimension)?

In the dimension limits you can only choose top 10 products for one expression...

I want the top 10 Products by sum(revenue) and by sum(orders)?

Re: Pie Chart graph filtered for Top 10

rubenmarin — Mon, 14 Dec 2015 14:48:02 GMT

Hi you can create two expressions, select the bottom expression the 'Group' button will be active:

Int he chart you'll see the icon, where the user can select the expression. The dimension limits works with the active expression selected by user.

Re: Pie Chart graph filtered for Top 10

puttemans — Mon, 14 Dec 2015 14:54:47 GMT

Hi,

Is this something you can do, based upon your data? How would you imagine it? I can imagine quite some issues in defining rules. e.g. a cheap product that gets a lot of orders vs an expensive one that gets much lower offers so that revenue is similar (and should be in top 10). How would you deal with this? Imagining you have other products that make up the top 10 in order lines apart from the expensive one.

My solution would be to have 2 different pie charts in a container instead of wanting to combine them in one chart.

Kind regards,

Johan