Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
lmcarter
Contributor II
Contributor II

Pie chart: Creating two fields - Group with max group sum and sum of all other groups

Hi all

I have data that looks like the following:

 

GroupAmount
Group 11
Group 1

2

Group 13
Group 22
Group 23
Group 31
Group 32
Group 33
Group 31

I am wanting to create a pie chart (as a KPI) that shows the sum of all amounts for the max group compared to the sum of the rest of the groups added together - obviously the 'max group' will change when more data gets added to the data set so the pie chart needs to be fluid.

The way I am wanting to get the data to graph looks like this:

GroupAmount
Group 37
Other11

The pie would look something like this (Where the orange is the added amounts for all other groups and the grey is the added amounts for the group that has the max added value amounts for it's group)

Capture.PNG

1 Solution

Accepted Solutions
Ivan_Bozov
Luminary
Luminary

Hello! Do this:

Dimension: Group

Measure: Sum(Amount)

Apply this settings in the Data tab:

Capture.PNG

View solution in original post

1 Reply
Ivan_Bozov
Luminary
Luminary

Hello! Do this:

Dimension: Group

Measure: Sum(Amount)

Apply this settings in the Data tab:

Capture.PNG

View solution in original post