Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Visual Cue expression

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.

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Check background expression in Dimension, check attached screenshot.

Regards,

Jagan.

View solution in original post

4 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Hope attached file helps you. 

Regards,

Jagan.

Not applicable
Author

Thanks for the reply, I see how the script works, but how did you make it red?

jagan
Luminary Alumni
Luminary Alumni

Hi,

Check background expression in Dimension, check attached screenshot.

Regards,

Jagan.

Not applicable
Author

Spot on Thanks!