This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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?
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?
Visual Cues based off expression | Qlik Community
also you can use color mix expression as well
Colormix on Pivot table (multiple expressions)
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