Grouped Bar Chart with Custom dimension

[Anonymous]

I have to create a grouped bar chart with Quarters on the x-axis and Count of customers in a particular revenue bucket in the y-axis. The revenue buckets aren't equally sized.

Here's my revenue bucket dimension:

If(Aggr(Sum(CR_DOLLARS),CEC_QTR)>=1000000,'>=$1M',
 If(Aggr(Sum(CR_DOLLARS),CEC_QTR)>=100000,'>=$100K and <$1M',
 If(Aggr(Sum(CR_DOLLARS),CEC_QTR)>=10000,'>=$10K and <$10K',
 If(Aggr(Sum(CR_DOLLARS),CEC_QTR)>=1000,'>=$1K and <$10K',
 If(Aggr(Sum(CR_DOLLARS),CEC_QTR)>=1,'>=$1 and <$1K',
 '<$1')))))

My measure which is a count of customers is like this:

Count(If(Aggr(Sum([CR_DOLLARS]), CEC_QTR)>=1,CLEAN_END_CUSTOMER))

But the chart generated has the same color in all buckets. And all the bucket legends show up as >=$1M. 

If I use custom colors based on dimension, Qlik creates different buckets by itself.

What do I do?

[sunny_talwar]

Try this

Calculated Dimension

Aggr(
If(Sum(CR_DOLLARS) >= 1000000, '>=$1M',
If(Sum(CR_DOLLARS) >= 100000, '>=$100K and <$1M',
If(Sum(CR_DOLLARS) >= 10000, '>=$10K and <$10K',
If(Sum(CR_DOLLARS) >= 1000, '>=$1K and <$10K',
If(Sum(CR_DOLLARS) >= 1, '>=$1 and <$1K'))))), CEC_QTR)

Expression

Count(CLEAN_END_CUSTOMER)

[Anonymous]

Tried, but no change

[sunny_talwar]

Would you be able to share a sample to check this out?