topic Bar Chart Color by firstsortedvalue in App Development

Bar Chart Color by firstsortedvalue

Anonymous — Thu, 08 Mar 2018 18:27:12 GMT

I'm using the Adventureworks database and trying to set up the following bar chart:

Sales Amount by StateProvince Name, each bar colored by the top Occupation calculated as highest average Sales.

I expect to see a bar chart with each bar colored in one of the 5 colors corresponding to the 5 values in the Occupation dimension.

I was able to create an expression which brings me the top occupation using firstsortedvalue:

firstsortedvalue(EnglishOccupation,-Aggr ((sum($(vSalesUSD))/Count(CustomerKey)), EnglishOccupation, StateProvinceName))

However I can't make this same expresion work as a color differentiator in the Bar chart. What am I missing?

The expression works as expected in a simple table:

Re: Bar Chart Color by firstsortedvalue

Anonymous — Sat, 10 Mar 2018 05:30:31 GMT

any ideas?

Re: Bar Chart Color by firstsortedvalue

Anonymous — Wed, 14 Mar 2018 08:53:21 GMT

Not giving up on this, any ideas if this can be achieved and how?

Thanks!

Re: Bar Chart Color by firstsortedvalue

sunny_talwar — Wed, 14 Mar 2018 09:01:23 GMT

What is the exact expression you are using for your color expression?

Re: Bar Chart Color by firstsortedvalue

Anonymous — Wed, 14 Mar 2018 11:31:35 GMT

That's the problem, I don't know how I should use the above expression, which brings me correct results, for the color by expression field. I tried using it as it is and I only get grey bars...

Thanks for looking into this

Re: Bar Chart Color by firstsortedvalue

sunny_talwar — Wed, 14 Mar 2018 11:38:36 GMT

Would you be able to share a sample?

Re: Bar Chart Color by firstsortedvalue

Anonymous — Wed, 14 Mar 2018 18:08:30 GMT

Here it is. The first sheet should be self explanatory. I want to have the first chart colored by the English occupation, as the data shows in the table in the lower right side.

Everything else seems to be working ok.

Re: Bar Chart Color by firstsortedvalue

sunny_talwar — Wed, 14 Mar 2018 18:19:40 GMT

Something like this?

Re: Bar Chart Color by firstsortedvalue

Anonymous — Wed, 14 Mar 2018 19:21:24 GMT

exactly

Re: Bar Chart Color by firstsortedvalue

sunny_talwar — Wed, 14 Mar 2018 19:23:32 GMT

I have attached the sample back with my last response for you to take a look at

Re: Bar Chart Color by firstsortedvalue

Anonymous — Wed, 14 Mar 2018 19:33:12 GMT

Thanks, this does work, I actually thought about doing this but was hoping of some way which doesn't involve a list of fixed values.

The way I imagined this, without going in much depth about the actual logic, was that the result of the expression will be interpreted as a dynamic dimension, each of its values being dynamically assigned a color.

Am I that far off?

I will mark the answer as correct, even though my expectations were a bit different.

Re: Bar Chart Color by firstsortedvalue

sunny_talwar — Wed, 14 Mar 2018 19:44:55 GMT

I am not sure if there is another way or not, but may be omarbensalem‌ or youssefbelloum‌ might have ideas here

Re: Bar Chart Color by firstsortedvalue

YoussefBelloum — Wed, 14 Mar 2018 23:51:52 GMT

Thanks for tagging me Sunny.

Unfortunately now I am not able to add anything..it is beyond me. as soon as I find something interesting I will share it with you

Re: Bar Chart Color by firstsortedvalue

sunny_talwar — Thu, 15 Mar 2018 00:42:09 GMT

No problem at all... I just thought that since this is Qlik Sense question, you might have a better idea of its inbuilt functionality.... May be Omar can offer any advice still