Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mohan_1105
Partner - Creator III
Partner - Creator 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
sunny_talwar

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)

View solution in original post

4 Replies
rupamjyotidas
Specialist
Specialist

Probably create the bucket in script.

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

mohan_1105
Partner - Creator III
Partner - Creator III
Author

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

sunny_talwar

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
Partner - Creator III
Partner - Creator III
Author

Thanks for helping me once again, Sunny.