Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon, i'm struggling to get a script in the visual cue part of qlikview to work but I cant, here is an example of the data im trying to change
Customer number | Contract ref number
10001111 | ab01
10001111 | ab02
15215555 | ab15
I am trying to highlight the duplicate in red by using the expression :- if(count(distinct([Customer Number])))>'2'
while I understand you cannot have 2 distinct numbers it is represented as 2 or being shown twice if like in the above example thereare more than 2 contract reference numbers. How do I go about doing this?
Kind regards.
Paul.
Hi,
Check background expression in Dimension, check attached screenshot.
Regards,
Jagan.
Hi,
Hope attached file helps you.
Regards,
Jagan.
Thanks for the reply, I see how the script works, but how did you make it red?
Hi,
Check background expression in Dimension, check attached screenshot.
Regards,
Jagan.
Spot on Thanks!