Solved: How to change the comment colour based on member? - Qlik Community

Permalink · ‎2014-03-21

Hi,

In Straight,how can I change the Comment Colour based on Member.

Dimension: Member

Expression : Comment

i,e i would need the comment colours for corresponding Member

Please can anyone suggest me.

Gysbert_Wassenaar · ‎2014-03-21

Click on the + in front of the Expression, select background color and enter an expression to calculate a color. If you have less than 20 members you can use color(fieldindex('Member',Member). If you have a large number of members consider adding a color field to the members table. See this blog post for more information: Colors in charts

talk is cheap, supply exceeds demand

View solution in original post

Permalink · ‎2014-03-21

Sorry got it If(MixMatch(Member,'AA'),Green())

Is it possible to change the colours for each person comments with out adding one by one.

Gysbert_Wassenaar · ‎2014-03-21

Click on the + in front of the Expression, select background color and enter an expression to calculate a color. If you have less than 20 members you can use color(fieldindex('Member',Member). If you have a large number of members consider adding a color field to the members table. See this blog post for more information: Colors in charts

talk is cheap, supply exceeds demand

Permalink · ‎2014-03-21

Thanks. Perfect.