how to change the alternate segments color of single line chart in qlikview

[matrix123]

Hi,

Does anyone know how to change the color of alternate segments in a single line chart ?

I have datetime on X axis and text value on measure, I want to change the color of the segment based on the comparison of current to next value  (if they are same then use one color, otherwise another color)or altleast alternate segments to different color.

Thanks,

Matrix

[tresesco]

Try to share a sample app to work on.

[matrix123]

Hi treseco,

Attaching you a sample qvw file..I want to see segments ABC1234 in green color (it is appearing 2 times) and XYZ1234 is a different value, so different color.

Can this be done in qlikview?

I mean it is a single line but i want to show the segments (symbols) on the data values with different color...usually i have toggling values 2, and i dnt want to code in inline table...

for example in straight table we can change the alternate rows color by using something like

=if(mod(rowno(total),2)=0,red(),green())

i want to change alternate symbols in line with different color..

thanks.

[tresesco · Accepted solution]

Check the attached file. You would need one additional expression with only symbol presentation and background expression something like:

Color(FieldIndex('vlaue', vlaue))

[matrix123]

Thank you Tresesco..

It worked well for me..:-)

[aamirSiddiquee1]

 You would need one additional expression with only symbol presentation and background expression something like:
Color(FieldIndex('vlaue', vlaue)) .

Also you can add conditional color expression in the Main expression.

[matrix123]

And also it can be done in the single expression as well (by selecting both line and symbol), works well.

I accepted your solution as Color using Fieldindex given me what i was looking for...