Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
ID | element1 | element2 | element3 | element4 |
---|---|---|---|---|
A01 | 1.3 | 23 | 4.5 | 5 |
A02 | 1.4 | 26 | 4.8 | 3 |
A03 | .8 | 28 | 5 | 2.3 |
A04 | 1.9 | 22 | 4.3 | 2.1 |
I want create a pie chart for the above mentioned data.
Whenever I select a ID Piechart should be show the values of element1 to element4.
Please guide how to do?
Thanks in advance.
like this?
a:
LOAD
ID, element1, element2, element3, element4
FROM
[https://community.qlik.com/thread/190538]
(html, codepage is 1252, embedded labels, table is @1);
b:
CrossTable (field, element) LOAD * Resident a;
DROP Table a;
First Create Crosstable(Element, Values)
Then take pie chart with Element as Dim
Expression: sum(Values)
Now, whenever you select ID, you will be getting associated Elements values...