Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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?
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
Maybe you could just use a pivot table
instead of a straight table?
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.
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!
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.
it doesn't work 😞
Seems to work for me though
Can you please post a sample application that demonstrates this issue to test with?
thanks
Marco