Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Customising the colours on a stacked graph

Hi all,

I am trying to change the colours of the segments in a stacked graph, the current expression that I am using is:

pick(match(Director,'K1','E1'),LightRed(),LightGreen())

There are only 2 segments in the stacked graph, and 5 teams. The graphs show the positive and negative score for each team. How do I put this into an expression to customise the negative section to red and the positive section to green?

Thanks,

Angharad