Discussion board where members can get started with Qlik Sense.
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?
Change your origin table in the script as follow:
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)
You can achieve this by using Crosstab option. Please find attached qvf.
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
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 for the reply.
I couldn't sort out how to use crosstable, so I've changed my source table