Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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?

2 Replies
swuehl
MVP
MVP

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
Specialist II
Specialist II

hi,

use aggr()