Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
sudhir0538
Creator
Creator

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

IDelement1element2element3element4
A011.3234.55
A021.4264.8

3

A03.82852.3
A041.9224.32.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.

2 Replies
maxgro
MVP
MVP

like this?

1.png

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;

Anonymous
Not applicable

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