Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

tracycrown
Contributor II

Pie Chart and Colour

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 

Labels (1)
4 Replies
ramasaisaksoft
Valued Contributor III

Re: Pie Chart and Colour

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
Contributor II

Re: Pie Chart and Colour

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

 

 

MVP & Luminary
MVP & Luminary

Re: Pie Chart and Colour

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

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

tracycrown
Contributor II

Re: Pie Chart and Colour

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