Highlight corresponding rows

[cpalbrecht]

Hi together,

I want to do the following. I have a table like this:

Date	Value
Date1	V1
Date1	V2
Date1	V3
Date2	V4
Date2	V5
Date3	V6
Date4	V7
Date4	V8
Date4	V9

And I want to display the table like this:

Date	Value
Date1	V1
Date1	V2
Date1	V3
Date2	V4
Date2	V5
Date3	V6
Date3	V7
Date3	V8
Date4	V9
Date5	V10
Date5	V11
Date6	V12
Date6	V13
Date6	V14

I want to highlight alternately corresponding rows based on the date column.

Does anybody have an idea how to do this?

BR

Nachricht geändert durch Christoph Albrecht Updated table.

[Gysbert_Wassenaar]

Recent versions of Qlik Sense allow you to use expressions to set the background color of column cells. You can try something like =if(even(max(total <Date> aggr(RowNo(),Date))),LightGray(200),White())

[cpalbrecht]

Hey Gysbert,

thanks for your answer. I updated the table. So the number of corresponding rows are not always even or odd.

BR

[petter]

Then it could be done like this:

=Pick(FMod((Index(Concat(TOTAL DISTINCT Date,'||',Date),Date)-1)/12,2)+1,Green(50),White())

The number 12 in the expression above has to be adjusted to the number of characters in your date format. The ISO date format of YYYY-DD-MM plus the separators || gives 12.

This is a reliable way of determining even and odd groups of dates.

[cpalbrecht]

Thanks Petter, this is also working!

BR

[petter]

So did it solve your problem then? If so please mark the thread as answered and if you want helpful....