topic Visual cues: does it take set analysis? in QlikView

Visual cues: does it take set analysis?

sibrulotte — Fri, 21 Feb 2014 14:21:18 GMT

Hi,

so in a visual cue, I would like my field ("Écart", which is french for difference, or discrepency) to light up when this condition is respected:

Above >=

0.1*(sum({$<[%CLE_Type_Transaction_ID] = {'EB', 'EA'}, [Unité administrative ID]-={'0000'} >}[Montant cumulé aad] * %CR004M))

Unfortunatly this doesn't work. I've made a field of that expression just to validate the results make sense, and they do! I get 10% of my budget to show up in a field all lined up next to that discrepency field. But the visual cue doesn't work

What am I doing wrong?

Re: Visual cues: does it take set analysis?

Clever_Anjos — Fri, 21 Feb 2014 14:23:00 GMT

Use Expression Background color (Expressions Tab) is more flexible than Visual Cues

Re: Visual cues: does it take set analysis?

sibrulotte — Fri, 21 Feb 2014 15:18:04 GMT

yeah, that worked in an instant....

Just have to know your colour codes.

Thanks a bunch