topic Re: Bar Chart background color definition for each expression in App Development

Bar Chart background color definition for each expression

FleetingImage — Sat, 16 Nov 2024 00:58:26 GMT

Hi,

I'm trying to replicate a bar chart from QlikView into QlikSense. This is what I have in QlikView:

The chart uses 1 dimension: months of the year, and 2 expressions:

SalesCYear (blue bars): sales from this year

SalesPyear (yellow bars): sales from the prior year

For each of these I defined the color, setting the background color attribute:

The formula is:

if(Only({<Month=>}MONTH_NUM)=$(vYtdMaxdMonth),RGB(0,128,192),ARGB(100,0,128,192))

And in this case, vYtdMaxMonth = 10

The idea is that for the current month of the year (in the example is October) the color of the bar is RGB() and for the rest of the months the color is lighter (ARGB()), so the current month looks highlighted.

I haven't been able to figure out how to do this in QlikSense, any ideas?

Re: Bar Chart background color definition for each expression

pradosh_thakur — Thu, 10 Dec 2020 09:24:23 GMT

Use the exression as a master measure. Use the desired RGB expression there for color.

Re: Bar Chart background color definition for each expression

FleetingImage — Thu, 10 Dec 2020 23:42:21 GMT

Hi Pradosh,

Could you please share with me an example?, when you say "there" is where exactly?

Thanks

Re: Bar Chart background color definition for each expression

FleetingImage — Fri, 11 Dec 2020 06:40:27 GMT

I was able to (kind of) solve the problem using the solution posted here:

https://community.qlik.com/t5/Qlik-Sense-Documents/Qlik-Sense-How-to-set-custom-colors-by-measure-in-a-bar-chart/ta-p/1480871

This is the result:

The only thing I would like to change is that I only want to show the number of the month and not that second label. Any idea on how to remove it?