topic Re: Highlight duplicate values in straight table in App Development

Highlight duplicate values in straight table

danimarc12 — Fri, 03 Dec 2021 10:56:56 GMT

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!

Re: Highlight duplicate values in straight table

abhijitnalekar — Fri, 03 Dec 2021 13:42:22 GMT

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?

Re: Highlight duplicate values in straight table

danimarc12 — Fri, 03 Dec 2021 13:53:07 GMT

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

Re: Highlight duplicate values in straight table

MarcoWedel — Fri, 03 Dec 2021 17:02:54 GMT

Maybe you could just use a pivot table

instead of a straight table?

Re: Highlight duplicate values in straight table

danimarc12 — Fri, 03 Dec 2021 17:13:25 GMT

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.

Re: Highlight duplicate values in straight table

danimarc12 — Fri, 03 Dec 2021 17:17:20 GMT

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!

Re: Highlight duplicate values in straight table

MarcoWedel — Fri, 03 Dec 2021 17:45:06 GMT

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.

Re: Highlight duplicate values in straight table

danimarc12 — Fri, 03 Dec 2021 17:54:47 GMT

it doesn't work 😞

Re: Highlight duplicate values in straight table

MarcoWedel — Fri, 03 Dec 2021 20:10:42 GMT

Seems to work for me though

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

thanks

Marco