Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

steve_br
New Contributor III

Pie chart and text values

Hello!

I have the following data consisting only of text fields:

CustomerProduct
CustomerAProduct1
CustomerAProduct2
CustomerAProduct1
CustomerAProduct2
CustomerAProduct3
CustomerBProduct2
CustomerBProduct2
CustomerBProduct3
CustomerBProduct2
CustomerBProduct1
CustomerCProduct3
CustomerCProduct2
CustomerCProduct2
CustomerCProduct3
CustomerCProduct2

I want to create a pie chart that shows the total percentage of the products (Product1 = 20%, Product2 = 53,33%, and Product3 = 26,67%). I would also like to include the Customer field as a filter so that the pie chart updates according to the selection I make.

I really hope that somebody can help me out here. Thank you!

1 Solution

Accepted Solutions
MVP
MVP

Re: Pie chart and text values

Try a chart with dimension Product and expression

=Num( Count(Product) / Count(TOTAL Product) , '#.00%')

[or use Count(Product) with relative option and format using number tab]

The chart should be sensitive to filtering in Customer field by default.

3 Replies
MVP
MVP

Re: Pie chart and text values

Try a chart with dimension Product and expression

=Num( Count(Product) / Count(TOTAL Product) , '#.00%')

[or use Count(Product) with relative option and format using number tab]

The chart should be sensitive to filtering in Customer field by default.

bellamae
Valued Contributor

Re: Pie chart and text values

You should be able to create a pie chart with the expression count(Product). By dragging the pic chart icon onto the sheet, you can use the field Product as your dimension and the expression count(Product) as your measure.

Capture20.PNG

and create a filter pane with Customer. By dragging the filter pane icon onto the sheet and add Customer as the dimension

Capture21.PNGCapture22.PNG

steve_br
New Contributor III

Re: Pie chart and text values

Thank you both! It worked!

Community Browser