Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

1 Solution

Accepted Solutions

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

Is this what you envisioned?

Capture.PNG

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
rupamjyotidas
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, .....)

mohan_1105
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

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

Is this what you envisioned?

Capture.PNG

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)

mohan_1105
Contributor III

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

Thanks for helping me once again, Sunny.

Community Browser