QlikSense Custom Coloured Bar Chart

[dberkesacn]

Hi All,

I have a line chart in QlikSense.

its has

     one dimension MonthYear, and

     two expression

          sum({<Product={'PRODUCT1'}>}Amount) and

          sum({<Product={'PRODUCT2'}>}Amount)

I would like to assign two different custom colour for each of them and used color by expression with the following formula: IF(match(Product,'PRODUCT1'),colour_2,colour_2).

it hasnt worked.

any suggestion?

Thanks,

Daniel

[arulsettu]

check this

Qlik Sense: How to set custom colors by measure in a bar chart

[dberkesacn]

hi this wont solve my problem since what i would like to achive is not coloring by DIMENSION VALUE but would like to assigne a color for one expression and another color for the other expression.

Daniel

[brunobertels · Accepted solution]

Hi

Try this

https://community.qlik.com/message/1078261#1078261

[Patrik_Lundblad]

Hi Daniel,

If you are using Qlik Sense 3.2 or later you can just add the expressions as measure to your library and then you can assign one color per measure. These colors are then used in the visualizations.

Best regards,

Patrik.

[dberkesacn]

unfortunately using 3.1 I know 3.2 and Jun release but i have to solve the issue in 3.1.

going to try Bruno suggestion which could work as I checked it.

[dberkesacn]

This is working, tried out, thanks Bruno.