Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pie Charts from Multiple Columns

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??

2 Replies
jagan
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

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.