Highlight duplicate values in straight table

[danimarc12]

Hello everyone!

I have this table 

and I want to highlight the duplicate values in white to obtain this result:

Could anyone help me to solve my issue?

Thank you all!

[abhijitnalekar]

Hi @danimarc12 ,

Can you please explain the scenario in detail please, as the above two tables have irrelevant data to each other which leads to confusion about what exactly needs to do?

[danimarc12]

Hi @abhijitnalekar ,

basically the first image is my table. I want to color white the font of the duplicate values to obtain the result you see in the second image. The second image is just an example.

I think, in the dimension color text expression, I have to write something like:

if(count( Total <ID ordine>  ID ordine) > 1 , White()).

But I don't want to color all the rows, I want to color from the second duplicate. 

The result I want to reach is this one:

 (on the right I have more columns).

I don't know if I'm clear 

[MarcoWedel]

Maybe you could just use a pivot table 

instead of a straight table?

[danimarc12]

Hi @MarcoWedel , thanks for your answer!

I'm using the pivot table but I don't like that the header of the columns are not over the column as the straight table. As you can see, if I have a lot of columns it's gonna be difficult to understand the argument of the column.

[danimarc12]

https://community.qlik.com/t5/Suggest-an-Idea/column-headers-display-on-pivot-table/idi-p/1784649

Look at this post. The user Patric_Nordstrom did it!

[MarcoWedel · Accepted solution]

I see, didn't know this post.

I think you could use a text color expression like

If(RowNo()>1,White(0))

  to achieve this result in a table.

[danimarc12]

it doesn't work 😞

[MarcoWedel]

Seems to work for me though

Can you please post a sample application that demonstrates this issue to test with? 

thanks

Marco