Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to use sum in pie chart?

Good day,

I would really appreciate if someone could help me with pie charts

We have a table which contains sales info per manager and looks like this:

Date
Manager 1Manager 2
23.02.2017115007000
24.02.201702000
25.02.20173500700
26.02.2017010000
27.02.201750000
etc

I need to make a pie chart that shows sum of sales per manager.

piechart1.jpg

How can I do it in Qlik Sense?

Tags (3)
4 Replies
OmarBenSalem
Esteemed Contributor

Re: How to use sum in pie chart?

Change your origin table in the script as follow:

crosstable(Managers, Sales)

load

*

from your source :

With that you'll have a new field called Managers which contains manager1 and manager 2, and a new field called sales:

In your pie chart, you just choose as dimension: Manager and as a measure: sum(Sales)

ganeshreddy
Contributor III

Re: How to use sum in pie chart?

Hi ,

You can achieve this by using Crosstab option. Please find attached qvf.

Capture111.PNG

Thanks,

Gnaesh

Not applicable

Re: How to use sum in pie chart?

I couldn't figure out how to use crosstable. Despite familiarizing with QlikView Manual.

But still I understood that I need to change source table

So I moved from

DATE | MANAGER 1 | MANAGER 2

to

SALE No. | MANAGER | SALE DATE | COST

and then I used Manager as a dimension and Sum(Cost) as measure. That did the trick

Thank you.

Not applicable

Re: How to use sum in pie chart?

Thank you for the reply.

I couldn't sort out how to use crosstable, so I've changed my source table

Community Browser