Coloring RowNo() issue

sergio0592 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Coloring RowNo() issue

tresB — Mon, 30 Mar 2020 10:58:34 GMT

Use NoDistinct with aggr(), like:

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

Re: Coloring RowNo() issue

sergio0592 — Mon, 30 Mar 2020 11:29:35 GMT

Thanks!

topic Coloring RowNo() issue in QlikView

Coloring RowNo() issue

Re: Coloring RowNo() issue

Re: Coloring RowNo() issue