topic Re: pie graphic in QlikView

pie graphic

rafael5958 — Mon, 27 Jul 2015 14:03:22 GMT

HI, I have this situation:

columnA ColumnB ColumnC

A 10

B 20

C 50

John D 10

John D 30

Paul E 80

I need a pie graphic with column A as a dimension and sum the Column C values when equals. Like:

columnA ColumnB ColumnC

A 10

B 20

C 50

John D 40

Paul E 80

How can I do that? When I select the blank space on column A it shows only one element on graphic instead of the three.

Re: pie graphic

sunny_talwar — Mon, 27 Jul 2015 14:13:48 GMT

Is this what you are looking for?

Dimension: =ColumnA & '|' & ColumnB

Expression: =Sum(ColumnC)

Re: pie graphic

MarcoWedel — Mon, 27 Jul 2015 21:02:14 GMT

Hi,

another solution could be:

LOAD *,
    Dual(ColumnA,AutoNumberHash128(ColumnA,ColumnB)) as ColumnAB
INLINE [
    ColumnA, ColumnB, ColumnC
    " ", A, 10
    " ", B, 20
    " ", C, 50
    John, D, 10
    John, D, 30
    Paul, E, 80
];

hope this helps

regards

Marco