topic Pie Charts from Multiple Columns in QlikView

Pie Charts from Multiple Columns

Mon, 20 Feb 2012 15:57:39 GMT

Hi all,

I have 10 columns which have an 'hours' figure in them (as in hours of audio)

I'd like to create a pie chart that shows the sum of all the rows in each column as a percentage but i'm struggling to achieve this! I have added all 10 columns as dimensions, but what should my expression be??

Pie Charts from Multiple Columns

jagan — Mon, 20 Feb 2012 16:05:52 GMT

Hi,

Can you attach the sample data file. It helps in understanding the problem. The max limit of Dimensions in only 3.

After that the expressions are ignored. The dimensions are also limited based on the graph you choose.

Regards,

Jagan.

Pie Charts from Multiple Columns

Mon, 20 Feb 2012 16:08:23 GMT

Thanks for the reply, sadly i can't really post the data file but it is a table of:

Year (Derived from Date on Reload), Date (yyyy-mm-dd), Hours1, Hours2, Hours3, Hours4, Hours5, Hours6, Hours7, Hours8, Hours9, Hours10

Ideally i want a pie chart saying for a year Hours1 was 20%, Hours2 was 10%, Hours3 was 5% etc.