Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
FelixvS
Contributor
Contributor

Pie chart problems

Hello good people, 
I just started working with Qlik-sens, and i cant seem to manage to create a decent Pie chart. The problem im struggeling with is finding the right inputs to use for the measure and dimensions. I want to make a Pie chart displaying the average of the 4 data colums shown in the attechment. 

Any help would be highly appreciated :).

Attechtment 1.jpeg

5 Replies
Kushal_Chawda

Create a pie chart with Dimension and below measure

=RangeAvg (ExpressionForTotaal HoTT, ExpressionForTotaal Incidentaal,....)

FelixvS
Contributor
Contributor
Author

I'm not quite sure what you mean by this?  Is the ''=RangeAvg (ExpressionForTotaal HoTT, ExpressionForTotaal Incidentaal,....)'' statement supposed to be put  for Fx in the expression for the measures? and What kind of Dimension should i choose then?

Kushal_Chawda

Yes, for the first part of your question. You can choose any dimension based on your requirement. If you can share sample data with expected output, it will be helpful

FelixvS
Contributor
Contributor
Author

I would like to see a pie chart showing the average values of these for coloms, so;
29,2%
27,5%
31,25%
12,1%.

But im not sure wich dimension to choose to get these values.

FelixvS
Contributor
Contributor
Author

 these four columns*