# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor III

## How to bucket the calculated value in pie chart dimension?

Hi,

I am trying to visualize the number of customers who falls in the specified bucket category. Bucket category is based on probability I calculated (Please take a look at sample App). I wanted to see the bucket proportion in a pie chart. I cannot able to specify the bucket name in chart dimension.

Please help me to build the chart and also please make me understand why pie chart cannot have calculated dimension like straight does.

A sample file is attached with this discussion.

Thanks,

Mohan.

Tags (2)
1 Solution

Accepted Solutions
MVP

## Re: How to bucket the calculated value in pie chart dimension?

Is this what you envisioned?

Dimension

=Aggr(if((count(distinct BILLDATE) / Count({<CATEGORY=>} distinct BILLDATE)) >= '0.8','A',

if((count(distinct BILLDATE) / Count({<CATEGORY=>} distinct BILLDATE)) >= '0.5','B',

'C')), CUSTOMER)

Expression

Count(DISTINCT CUSTOMER)

4 Replies
Valued Contributor

## Re: How to bucket the calculated value in pie chart dimension?

Probably create the bucket in script.

If(Sum(Customer)>1 and SUm(Customer)<10, 1-10, .....)

Contributor III

## Re: How to bucket the calculated value in pie chart dimension?

Hi Rupam,

Yeah, definitely that will work and also make the work easier. But unfortunately, I have set inside my expression. Please have a look at my app. You will get to know the problem I face actually.

Thanks

MVP

## Re: How to bucket the calculated value in pie chart dimension?

Is this what you envisioned?

Dimension

=Aggr(if((count(distinct BILLDATE) / Count({<CATEGORY=>} distinct BILLDATE)) >= '0.8','A',

if((count(distinct BILLDATE) / Count({<CATEGORY=>} distinct BILLDATE)) >= '0.5','B',

'C')), CUSTOMER)

Expression

Count(DISTINCT CUSTOMER)

Contributor III

## Re: How to bucket the calculated value in pie chart dimension?

Thanks for helping me once again, Sunny.