topic Re: Visual Cue expression in QlikView

Visual Cue expression

Mon, 23 Apr 2012 13:07:25 GMT

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.

Re: Visual Cue expression

jagan — Mon, 23 Apr 2012 13:29:07 GMT

Hi,

Hope attached file helps you.

Regards,

Jagan.

Visual Cue expression

Mon, 23 Apr 2012 13:54:16 GMT

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

Re: Visual Cue expression

jagan — Mon, 23 Apr 2012 14:14:14 GMT

Hi,

Check background expression in Dimension, check attached screenshot.

Regards,

Jagan.

Visual Cue expression

Mon, 23 Apr 2012 15:33:56 GMT

Spot on Thanks!