topic Re: Visual cues based on an expression in QlikView

Visual cues based on an expression

helen_pip — Tue, 28 Feb 2017 08:59:54 GMT

Dear Qlikview user

I have a pivot table, which contains a drill down group as a dimension. Due to the structure of my dataset I am unable to set the visual cues with the Background Color of the expression

My dimension is splitting data by Department and each department has a different target, so I was wondering whether the visual cues section can cope with various targets?

I.e.

If(Department = 'A', 0.93,

If(Department = 'B, 0.86,

If(Department = 'C', 0.85)))

I have tried putting this type of expression in, but it doesn't seem to work....I just need to know whether visual cues has any limitations with regards to working with numerous targets?

Kind Regards

Helen

Re: Visual cues based on an expression

dsharmaqv — Tue, 28 Feb 2017 09:14:29 GMT

try this

Visual Cues based off expression | Qlik Community

also you can use color mix expression as well

Colormix on Pivot table (multiple expressions)

Re: Visual cues based on an expression

avinashelite — Tue, 28 Feb 2017 09:14:38 GMT

It will work but I think you need to Select the Particular department for the same ..try selecting A and check ..

other way is to handle this in the expression tab >click on + > Text color