How to correctly load data/create pie chart?

[cawestelaken]

Hello reader,

I've got a small table such as below:

Identifier	Value A	Value B	Value C	Value D	Value E
V1	1	2	3	4	5
V2	5	4	3	2	1
V3	3	4	5	1	2
V4	2	1	5	4	3

Now what I'd like to create is a pie chart, showing me the percentage of the values in the rows per value. So for instance, I'd make a pie chart for V1, 1/15th value A, 2/15th Value B, 3/15th Value C, 4/15th Value D, and 5/15th Value E.

Would it be easier to transform this table in a certain way, or is this already possible but am I simply being clueless at the moment?

Your sincerely,
Casper Westelaken

[OmarBenSalem · Accepted solution]

Change ur table as follow:

Crosstable(Value,Measure)

load Identifier, "Value A","Value B","Value C","Value D","Value E" from source

Now, in ur pie chart, use :

dimension: Value

Measure: Sum(Measure)

[tomasz_tru]

First look here: https://www.darkhorseanalytics.com/blog/salvaging-the-pie

[cawestelaken]

I assume you mean for me not to use the Data Manager to load the excel sheet?

[cawestelaken]

Haha, in that case the question still counts for a bar chart

[OmarBenSalem]

U can perform crosstable using the data manager :

Unpivoting crosstable data in data manager - Qlik Sense - YouTube

I just prefer using the script to control everything

[cawestelaken]

This was indeed the case, thank you very much!