Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Use NoDistinct with aggr(), like:
if(even(aggr(NODISTINCT RowNo(),Personne)),LightGreen(), LightRed())
Use NoDistinct with aggr(), like:
if(even(aggr(NODISTINCT RowNo(),Personne)),LightGreen(), LightRed())
Thanks!