How to use sum in pie chart? - Qlik Community

Report Inappropriate Content · ‎2017-03-01

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:

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

How can I do it in Qlik Sense?

OmarBenSalem · ‎2017-03-01

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 · ‎2017-03-01

Hi ,

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

Thanks,

Gnaesh

Report Inappropriate Content · ‎2017-03-02

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.

Report Inappropriate Content · ‎2017-03-02

Thank you for the reply.

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