Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
rafael5958
New Contributor III

pie graphic

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.

1 Solution

Accepted Solutions

Re: pie graphic

Is this what you are looking for?

Capture.PNG

Dimension: =ColumnA & '|' & ColumnB

Expression: =Sum(ColumnC)

2 Replies

Re: pie graphic

Is this what you are looking for?

Capture.PNG

Dimension: =ColumnA & '|' & ColumnB

Expression: =Sum(ColumnC)

Re: pie graphic

Hi,

another solution could be:

QlikCommunity_Thread_174148_Pic1.JPG

QlikCommunity_Thread_174148_Pic2.JPG

QlikCommunity_Thread_174148_Pic3.JPG

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

Community Browser