topic Create Chart from Pivot Table Subtotals in QlikView

Create Chart from Pivot Table Subtotals

Sun, 13 Apr 2014 12:24:31 GMT

Hi!

I am trying to create a pie chart from a pivot table subtotals I created. Is this even possible? Do I have to create a separate pie chart with a lot of dimensions to match my pivot table dimensions?

Re: Create Chart from Pivot Table Subtotals

swuehl — Sun, 13 Apr 2014 12:35:23 GMT

You can't retrieve the subtotal values of a pivot table chart from another chart, like a pie chart, so you need to consider a way using a dimension and an expression (maybe using advanced aggregation) to get what you want.

But you need to explain your setting in more detail, if you want someone to help you. It would be best to upload a small sample application that demonstrates your issue.

Re: Create Chart from Pivot Table Subtotals

preminqlik — Sun, 13 Apr 2014 13:10:19 GMT

hi,

use aggr()