topic expression colour in straight table in QlikView

expression colour in straight table

Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Is it possible to colour the expression based on the value of dimensions?

for eg:, my table has Dimension Field1 : Red, Green, Orange

Expression : count(expression)

i need to give different colurs to the expression value.

if Field1 ='Red', whitecolour for expression, if Field1= 'Orange', blue colour for expression.

is it possible? if so, can someone please help with expression?

sunny_talwar — Thu, 27 Oct 2016 14:43:22 GMT

I think you sure can...May be like this

Pick(Match(Field1, 'Red', 'Orange', 'Green'), White(), Blue(), Green())

Anil_Babu_Samineni — Thu, 27 Oct 2016 14:44:48 GMT

What do you mean the dimension colors here

Thu, 27 Oct 2016 14:48:00 GMT

no sunny its not working

Thu, 27 Oct 2016 14:48:50 GMT

Anil,

i want to give colours to expressions not dimensions

sunny_talwar — Thu, 27 Oct 2016 14:51:36 GMT

Can you show your table how it looks?

Thu, 27 Oct 2016 15:00:46 GMT

sunny, picture attached

sunny_talwar — Thu, 27 Oct 2016 15:07:17 GMT

I don't seen any issues

Thu, 27 Oct 2016 15:16:03 GMT

Its working sunny.

one more thing, if i select the any value in the 'Field1' in a list box, the value of my expression shouldnt change in this table.

my expression is count(callsanswered). if any calendar selection is made, then it should reflect the change.

can you please help?

sunny_talwar — Thu, 27 Oct 2016 15:18:55 GMT

So changes based on selection in Field1?

May be this?

Count({<Field1>}callsanswered)

Color will change like this:

Pick(Match(Only({<Field1>}Field1), 'Red', 'Orange', 'Green'), White(), Blue(), Green())

Thu, 27 Oct 2016 15:32:36 GMT

Thank you so much sunny. it worked.