topic Re: Pie Chart and Colour in QlikView

Pie Chart and Colour

tracycrown — Sat, 16 Nov 2024 19:58:29 GMT

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 — Thu, 03 Oct 2019 13:18:50 GMT

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 — Thu, 03 Oct 2019 15:24:28 GMT

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 — Thu, 03 Oct 2019 17:56:03 GMT

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

tracycrown — Fri, 04 Oct 2019 00:21:17 GMT

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