topic Re: Pie Charts: One dimension and multiple expressions in QlikView

Pie Charts: One dimension and multiple expressions

Anonymous — Sun, 21 Jun 2015 17:08:17 GMT

Hello,

I am looking for some help in building the pie chart. I have a scenario where I need to build a pie chart to show the analysis of sales , for example I have 3 locations lets say loaction1,location2,location3 ,I need to show the sales in each location as per the year for last 3 years, like location1 sales for year 2015,2014,2013 and similarly for other locations.Can I achieve this using Pie chart. On the whole I need to have one dimension which would be location and sum(sales per year) for past 3 years as expressions.

Any help is highly appreciated.

Thanks

heera

Re: Pie Charts: One dimension and multiple expressions

swuehl — Sun, 21 Jun 2015 17:13:59 GMT

How should the pie chart look like with these requirements?

You can use two dimensions, location and year, and your aggregated sales and check if this fullfills your requirements.

Re: Pie Charts: One dimension and multiple expressions

MarcoWedel — Sun, 21 Jun 2015 23:27:32 GMT

restrict the years using a set expression.

Re: Pie Charts: One dimension and multiple expressions

Anonymous — Mon, 22 Jun 2015 00:52:08 GMT

Pie chart is good mostly for presentations, seldom for real analysis. You have not one but two dimensions - location and year. I recommend to use bar chart, stacked or grouped.

Re: Pie Charts: One dimension and multiple expressions

jagan — Mon, 22 Jun 2015 02:45:05 GMT

HI,

You need to use 2 Dimensions Location and Year, and the expression should be

=Sum({<Year={'$(>=Max(Year)-2)'}>}Sales)

I think the best method to display this in Trellis, where there is a separate Pie chart for each Location with years with the same dimensions and expression.

You can create Trellis by using

Chart Properties -> Dimensions -> Trellis -> Enable Trellis Chart

or use bar chart with above dimensions and expression and use Stacked option in Styles tab.

Hope this helps you.

Regards,

Jagan.

Re: Pie Charts: One dimension and multiple expressions

rwunderlich — Mon, 22 Jun 2015 05:06:07 GMT

You could make a single calculated dimension of

=location & '-' & year

That would give you one slice for each location & year combination,

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Pie Charts: One dimension and multiple expressions

hariprasadqv — Mon, 22 Jun 2015 05:14:34 GMT

Calculated Dimensions May help you!! Or you can try valuelist()

Re: Pie Charts: One dimension and multiple expressions

Anonymous — Wed, 24 Jun 2015 00:04:20 GMT

Thank you all. I tried Trellis and it worked. Thank you again for the response.