topic Re: How to add multiple non related fields in pie chart expression field in QlikView

How to add multiple non related fields in pie chart expression field

sudhir0538 — Fri, 06 Nov 2015 04:50:59 GMT

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.

maxgro — Fri, 06 Nov 2015 12:44:43 GMT

like this?

LOAD

ID, element1, element2, element3, element4

FROM

(html, codepage is 1252, embedded labels, table is @1);

CrossTable (field, element) LOAD * Resident a;

DROP Table a;

Anonymous — Fri, 06 Nov 2015 12:50:23 GMT

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...