Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
First look here: https://www.darkhorseanalytics.com/blog/salvaging-the-pie
I assume you mean for me not to use the Data Manager to load the excel sheet?
Haha, in that case the question still counts for a bar chart
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
This was indeed the case, thank you very much!