topic Re: Diagram with multiple pie charts in QlikView

Diagram with multiple pie charts

holgerkch — Fri, 05 Feb 2021 09:10:34 GMT

Hi,

I just installed QlikView for some private analysis work. I worked with QlikView in my job 10 years years ago, but unfortunately have forgotten a lot of "how to" due to not using it such a long time

Today I failed with two things:

Data imported from Excel, 4 columns:

- Group (examples: XX, YY)

- Key (examples: ABC, DEF, GHI, JKL)

- Original estimate (Example 100,50,40,30)

- Remaining estimate (Example 30,40,40,20)

First, I was not able to create a pie that shows in two segments the split between Remaining estimate and Original estimate.

In my example a pie with a segment of 70% and a segment of 30% for the data (100,30)

Maybe my brain stopped working, that sounds really simple, but I just do not get it arranged that way.

Second thing I have not found out, is if I can set up a diagram with multiple pies in one.

In my example I would like to have pies as described before for ABC, DEF, GHI in one diagram when I select group XX

Any input is welcome, from my work 10 years ago I remember that often it were just minimal thoughts that I was missing to be able to continue

Greetings from Switzerland

Holger

Re: Diagram with multiple pie charts

jneppl — Fri, 05 Feb 2021 10:19:22 GMT

Hi Holger,

i tried to structure your data in a different way using like the crosstable functionality.

Inline load table:

LOAD * Inline [

ID, estimate_type, value, group

ABC, original, 70, Y

ABC, remaining, 30, Y

DEF, original, 60, Y

DEF, remaining, 40, Y

GHI, original, 40, W

GHI, remaining, 60, W

JKL, original, 30, W

JKL, remaining, 70, W

];

Then i created a pie chart for example especially for ABC and i wanted to see two segments with 70 and 30.

Configuration of Pie chart:

Dim: estimate_type

Angle: sum({<ID={ABC}>} value)

Worked for me and you can create multiple pie charts next to each other. I hope this helps and you can create the other ones you need too.

Btw i did it in Qlik Sense.

Regards

Johannes

Re: Diagram with multiple pie charts

holgerkch — Fri, 05 Feb 2021 14:53:56 GMT

Thanks, Johannes, that got me a step forward.

I have some pie charts with the expected data now, but still struggling with the desired layout.

Will do some more try&error 😉

Re: Diagram with multiple pie charts

Norwood14 — Tue, 09 Feb 2021 04:36:24 GMT

@jneppl wrote: Nox Player
Hi Holger,
i tried to structure your data in a different way using like the crosstable functionality.

Inline load table:
LOAD * Inline [
ID, estimate_type, value, group
ABC, original, 70, Y
ABC, remaining, 30, Y
DEF, original, 60, Y
DEF, remaining, 40, Y
GHI, original, 40, W
GHI, remaining, 60, W
JKL, original, 30, W
JKL, remaining, 70, W
];

Then i created a pie chart for example especially for ABC and i wanted to see two segments with 70 and 30.
Configuration of Pie chart:

Dim: estimate_type
Angle: sum({<ID={ABC}>} value)

Worked for me and you can create multiple pie charts next to each other. I hope this helps and you can create the other ones you need too.

Btw i did it in Qlik Sense.

Regards

Johannes

Thanks johannes ,For help