Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
helen_pip
Creator III
Creator III

Visual cues based on an expression

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

2 Replies
dsharmaqv
Creator III
Creator III

avinashelite

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