Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Create Chart from Pivot Table Subtotals

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?

Tags (4)
2 Replies
swuehl
Not applicable

Re: Create Chart from Pivot Table Subtotals

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.

preminqlik
Not applicable

Re: Create Chart from Pivot Table Subtotals

hi,

use aggr()