topic Re: Pie Chart Based on Columns in QlikView

Pie Chart Based on Columns

Wed, 23 Oct 2013 10:00:00 GMT

I have a source data like this:

And I want a Pie Chart like this when I click the Client MY:

The problem is that I want to base myself on columns instead of rows. Should I make a table transformation first? If yes, how?

Thanks,

Miguel

Wed, 23 Oct 2013 10:21:18 GMT

I think I'm on the way.

What I did was enabling the transformation step when building the script and transposed the table.

Wed, 23 Oct 2013 11:09:41 GMT

I'm not sure if I really have to rotate the table.

Because I can have infinite clients, and then I need to have a listbox to select the client and auto update the pie chart.

So I don't know how to do this with rotating the table because I can have a non determined number of columns...

Thu, 24 Oct 2013 15:18:29 GMT

Any idea? Maybe if I change the source file first using some developer skills?

Fri, 25 Oct 2013 16:06:53 GMT

Done it!!!!!

PrePie:

Load @3 as Client,

@7 AS BRR_SerialNo,

@8 AS BRR_Status,

@9 AS BRR_RetireDate,

@10 AS BRR_City

FROM

[..\Data\foo.tabdel]

(txt, codepage is 1252, NO labels, delimiter is '\t', msq)

store PrePie into ..\QVD\~PrePie.qvd;

Pie:

CrossTable(Reason, Percentage)

LOAD Client,

BRR_SerialNo,

BRR_Status,

BRR_RetireDate,

BRR_City

FROM

[..\QVD\~PrePie.qvd]

(qvd);