Sector chart

[Aurél]

Hello,

I have the following data :

I'd like to make this graph (distribution of good parts/ not OK) with QlikSense :

I can’t do it because it must be a dimension!
I create this graph with QlikView without problems, without any dimension and with 2 measurements :
- Sum(QTE_OK)
- sum(QTE_NON_OK)

How can we do the same in QlikSense please?

Thank you.

[pedrobergo · Accepted solution]

Hi @Aurél 

You cannot use Pie Chart because it will need only one measure and dimension to separate the OK and NON_OK values. The best approach for you is creating a table on script that will separate it for you.

Considering that you have a OriginalTable, following script will create a newTable with Column TYPE that you´ll can use on Pie Chart and QTE field to unify the QTE_OK and QTE_NON_OK values:

NewTable:
Load Pieces,
     'OK' AS Type,
     QTE_OK AS QTE
Resident OriginalTable;
Load Pieces,
     'NON_OK' AS Type,
     QTE_NON_OK AS QTE
Resident OriginalTable;
Drop Table OriginalTable;

[],

Pedro