Count Distinct in color background expression

kiansin — Wed, 29 Mar 2023 09:20:07 GMT

Hi,

I need some help with an expression.

So it's partly correct, but it's based on the Count of orders in the excel file.
65-00-4011 - not highlighted: correct. There is only one occurrence in qlik table.
81-36-1090 - highlighted: correct. There are 3 occurrences in qlik table
81-36-8844 - highlighted: WRONG. There is only 1 occurrence in the Qlik table, even though there are 5 counts in excel.
82-90-1140 - highlighted: correct. There are multiple occurrences in the Qlik table (including a different description)

I am using the background color expression:
=if(aggr(nodistinct count([Article No.]), [Article des.]) > 1,rgb(255,128,0))

The problem is it is highlighting everything based on the database table, not the displayed table

Is there a way to highlight duplicates only on the table which I have built in the sheet?

Re: Count Distinct in color background expression

BrunPierre — Wed, 29 Mar 2023 19:57:48 GMT

How about this?

=Aggr(If(Count([Article No.])>1, rgb(255,128,0)), [Article No.])

topic Re: Count Distinct in color background expression in App Development

Count Distinct in color background expression

Re: Count Distinct in color background expression