Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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())
Hey Gysbert,
thanks for your answer. I updated the table. So the number of corresponding rows are not always even or odd.
BR
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.
Thanks Petter, this is also working!
BR
So did it solve your problem then? If so please mark the thread as answered and if you want helpful....