Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Bar Chart Colours

Hi, 

I am having issues when trying to colour my bar chart and wondered if anyone can shed some light on this please? 

Dimension: D_Date.autocalendar.month

Measure 1: =sum({<ddate_Y={'FY19'}>}Total_Val)

Measure 2: =sum({<ddate_Y={'FY20'}>}Total_Val)

I have then selected:

Colours > Custom > By Expression and added this logic:

if(ddate_Y='FY90',rgb(217,28,144),

if(ddate_Y='FY20',rgb(20,23,96)))

I have ticked 'The expression is a color code'

The chart then displays both measures as a Grey, any idea why this is please?

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hi,

try to create two master measures and then select the colors

View solution in original post

1 Reply
Highlighted
Partner
Partner

Hi,

try to create two master measures and then select the colors

View solution in original post