Pie Chart and Colour

tracycrown · ‎2019-10-01

Dear all

Kindly advise the followings asap:

1. How to take out the price in the inner circle of pie chart ?

2. How to customise/change manually the colour of pie chart ?.

Thank you

Tracy

ramasaisaksoft · ‎2019-10-03

Hi,

we were unable to open your .qvw file due to QlikView free/Personal edition.

so could you post your requirement in screen shots so that we can try to give solution for your issue.

tracycrown · ‎2019-10-03

Hi Mr Ramasaisaksoft

Please refer to script below:

LOAD Staff,
     Product,
     Price,
     Margin%
FROM
[Test-1.xls]
(biff, embedded labels, table is Sheet1$);

LOAD Product,
Tag
FROM
[Test-1.xls]
(biff, embedded labels, table is Sheet2$);

Thanks, Tracy

rwunderlich · ‎2019-10-03

I don't think your Dimensions are set correctly. See the attached QVW for suggested correction.

tracycrown · ‎2019-10-03

Dear Rwunderlich

Many thanks for your suggestion.

You only showed Tag but missed out the Product field, can you advise how to show both Product and Tag (in the inner circle) .

Thank you, Tracy