topic Re: Slice in Pie chart in QlikView

Slice in Pie chart

paulwalker — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I have one pie chart.. by default showing two slices...

My expression Count(Employee)

i have bucket, 1-5 years, 6-10 years

I have written Count({<Bucket={'1-5 Years'}>}Employee), but it showing 100% pie chart.

I want to show only 1-5 years slice Pink color slice.

Thanks in Advance...

Re: Slice in Pie chart

Chanty4u — Thu, 05 May 2016 05:30:17 GMT

try this

Count({<Bucket={'1-5 Years'}>}Employee)

Re: Slice in Pie chart

ajsjoshua — Thu, 05 May 2016 05:31:56 GMT

Hi,

syntax error

try tis

Count({<Bucket={''1-5 Years''}>}Employee)

Slice in Pie chart

Re: Slice in Pie chart

paulwalker — Thu, 05 May 2016 05:37:17 GMT

Sorry i written

Count({<Bucket={'1-5 Years'}>}Employee) Only..

But it's not working.... If i am write this it showing 100% pie chart..

I din't want to show 100%, i want show only piece of bucket (1-5 Years Percentage only)

Re: Slice in Pie chart

Chanty4u — Thu, 05 May 2016 05:41:08 GMT

try this

Count({<Bucket-={'1-5 Years'}>}Employee)

Re: Slice in Pie chart

ajsjoshua — Thu, 05 May 2016 05:41:12 GMT

Hi,

TRY IT

Count({<Bucket -={''1-5 Years''}>}Employee)

Re: Slice in Pie chart

Chanty4u — Thu, 05 May 2016 05:42:12 GMT

what is the error ur getting?

can u share sample for this?

Re: Slice in Pie chart

avinashelite — Thu, 05 May 2016 05:44:35 GMT

What is the dimension your using ???

Try like this

1.un-check the show in % in the expression

2.create a variable vSum = count({1}Employee)

3. add this expression

Count({<Bucket={'1-5 Years'}Employee>})/vSum

then go to numbers tab select the expression and check on numbers + show in %

hope this helps you

Re: Slice in Pie chart

avinashelite — Thu, 05 May 2016 05:45:17 GMT

Paul ,

try like this

Try like this

1.un-check the show in % in the expression

2.create a variable vSum = count({1}Employee)

3. add this expression

Count({<Bucket={'1-5 Years'}Employee>})/vSum

then go to numbers tab select the expression and check on numbers + show in %

Re: Slice in Pie chart

Kushal_Chawda — Thu, 05 May 2016 05:46:34 GMT

Dimension: Bucket

Expression: Count(Employees)

Background color Expression: if( Bucket ='1-5 Years', RGB(210,211,30),white())

Re: Slice in Pie chart

paulwalker — Thu, 05 May 2016 05:50:11 GMT

PFA

Re: Slice in Pie chart

paulwalker — Thu, 05 May 2016 06:00:38 GMT

HI Kushal,

Then how to remove black border??

Re: Slice in Pie chart

paulwalker — Thu, 05 May 2016 06:07:26 GMT

Already i have tried..

But not working..

Re: Slice in Pie chart

Kushal_Chawda — Thu, 05 May 2016 06:13:37 GMT

Just Go to Style Tab and choose the Pie Style without border

Re: Slice in Pie chart

paulwalker — Thu, 05 May 2016 06:17:02 GMT

already tried all styles.. but i want that particular slice only red color..

If i am changing style.. showing ash color

Re: Slice in Pie chart

Chanty4u — Thu, 05 May 2016 06:19:18 GMT

chk dis too

Re: Slice in Pie chart

Kushal_Chawda — Thu, 05 May 2016 06:22:21 GMT

see this

delete border of pie chart | Qlik Community

Re: Slice in Pie chart

avinashelite — Thu, 05 May 2016 07:58:46 GMT

Its working for me !!

would you please share the result of my suggestion ...whats the error or results

Re: Slice in Pie chart

awhitfield — Thu, 05 May 2016 08:53:04 GMT

Choose is one:

Andy