topic Re: Color previous row in straight table if the same in QlikView

Color previous row in straight table if the same

pauldamen — Thu, 15 Oct 2015 08:25:03 GMT

Hi,

I have a straight table with 10 dimensions, what I need is to make the previous text white if this is the same as the current row.

Reason is that for example the first column you see 40 times the same name in the column. So I just want to show the first and make the other 39 rows white.

I already tried the previous and row function but can't get it to work. Any ideas?

Regards, Paul

Re: Color previous row in straight table if the same

sujeetsingh — Thu, 15 Oct 2015 08:27:28 GMT

You can use Pivot table with expanded dimension or use some UI trick like text colour white after first cell.

Re: Color previous row in straight table if the same

settu_periasamy — Thu, 15 Oct 2015 08:32:43 GMT

Try to use the Above function in dimension background color or TextBackground Like

=if(Above(TOTAL DimName)=DimName,White(),Red())

Re: Color previous row in straight table if the same

pauldamen — Thu, 15 Oct 2015 08:32:50 GMT

Hi,

Thanks a pivot table will not work because of the data model. I am looking at the text colour trick, but how does the formula look to make next rows white if it is the same.

Regards, Paul

Re: Color previous row in straight table if the same

pauldamen — Thu, 15 Oct 2015 08:36:50 GMT

Thanks that was it! I was trying it the wrong way around with the dim name first and the above function after the =

Re: Color previous row in straight table if the same

settu_periasamy — Thu, 15 Oct 2015 08:43:13 GMT

Hi Paul,

It will work in both way..

=if(DimName=Above(TOTAL DimName),White(),Red())