Coloring RowNo() issue

[sergio0592]

Hi all,

I'am facing an issue about coloration lines. I have date set with Personne field. For each value of this field i'd like alternate colors -> For rows corresponding personne 1 red line, for personne 2 green line, for personne 3 red line etc,...

For this i used a dimension 

=aggr(RowNo(),Personne)

Its ok, i have a rowno() value for each Personne.

But when i use this in background color formula, it doesn't works

=if(even(aggr(RowNo(),Personne)),LightGreen(), LightRed())

So personne 2 should be green but there is only green for first row of Personne 2. See the attached .qvw file.

Thanks for your help.

[tresesco · Accepted solution]

Use NoDistinct with aggr(), like:

if(even(aggr(NODISTINCT RowNo(),Personne)),LightGreen(), LightRed())

[sergio0592]

Thanks!