Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulwalker
Creator III
Creator III

Slice in Pie chart

Hi Community,

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

My expression Count(Employee)

Capture.JPG

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

18 Replies
Chanty4u
MVP
MVP

try this

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

ajsjoshua
Specialist
Specialist

Hi,

syntax error

try tis

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

paulwalker
Creator III
Creator III
Author

Sorry i written

Count({<Bucket={'1-5 Years'}>}EmployeeOnly..

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)

Chanty4u
MVP
MVP

try this

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

ajsjoshua
Specialist
Specialist

Hi,

TRY IT


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

Chanty4u
MVP
MVP

what is the error ur getting?

can u share sample for this?

avinashelite

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


avinashelite

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 %


Kushal_Chawda

Dimension: Bucket

Expression: Count(Employees)

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