topic Re: Grouped Bar Chart with Custom dimension in App Development

Grouped Bar Chart with Custom dimension

Anonymous — Sat, 16 Nov 2024 21:46:30 GMT

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?

Re: Grouped Bar Chart with Custom dimension

sunny_talwar — Wed, 05 Dec 2018 12:45:16 GMT

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)

Re: Grouped Bar Chart with Custom dimension

Anonymous — Thu, 06 Dec 2018 05:48:41 GMT

Tried, but no change

Re: Grouped Bar Chart with Custom dimension

sunny_talwar — Thu, 06 Dec 2018 12:16:56 GMT

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