Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

ilanbaruch
Contributor III

background color expression stacked bar chart

Hi all

in my model i have a stacked bar chart with Company Name and quarter as a dimensions , 

showing largest 6 (dimension limit)

trying to set default color (in expression background color) for every company with below expression :

if(CompanyName='CompanyA',RGB(85,142,213),
if(CompanyName='CompanyB',RGB(229,182,148),
if(CompanyName='CompanyC',RGB(195,214,155),
if(CompanyName='CompanyD',RGB(27,125,156),
if(CompanyName='CompanyE',RGB(77,167,65),
if(CompanyName='CompanyF',RGB(128,120,64),
))))))

still colors are not persistent

 

any ideas ?

advanced thanks

1 Reply
Claudiu_Anghelescu
Contributor III

Re: background color expression stacked bar chart

try to put this on Dimension background color, not Expression background color
To help community find solutions, please don't forget to mark as correct.