Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
How about this?
=Aggr(If(Count([Article No.])>1, rgb(255,128,0)), [Article No.])