Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lightsection
Contributor III
Contributor III

Color Coding for each Measure in a Bar/Line chart

Is there a way to assign specific colors to each measure in a bat chart ? It would really great if someone can help on this.

Thanks,

4 Replies
rohitk1609
Master
Master

Hi Light,

You can't set a specific color any field or measure ,Yes what you can do you can set to multi color but you can't set as red is for field 1 or by your choice it will be set by automatically  or you can set color by values i.e less than 100 will be red , above will be green.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Rohit Kumar

Gysbert_Wassenaar

Not yet. You'd have to use a dummy dimension and single measure that uses a pick-match combination or if-statements. See this blog post for an example: Use Case for ValueList Chart Function


talk is cheap, supply exceeds demand
lakshmikandh
Specialist II
Specialist II

Hi Light,


As mentioned by gwassenaar using if or pick match statements in color by expression.

You can set a specific color to any dimension member of the Chart i.e if you have Branch as field and North,South,West,East as values you can set each one different color.

Thanks,

Lakshmikandh

shraddha_g
Partner - Master III
Partner - Master III

if you have 2 measure as Actual and Budget then you can create a dimension by using Valuelist as Valuelist('Actual','Budget').

In Measures Section Use it as pick(wildmatch(Valuelist('Actual','Budget'),'Actual','Budget'),sum(Filed_For_Actual),sum(Field_For_Budget) )

In Color by Expression :

pick(wildmatch(Valuelist('Actual','Budget'),'Actual','Budget'),red(),green())


I hope this is helpful.