Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set interval value with colors

hi everyone, I think this will be pretty easy for many, but I don't remember how to do it...

I need to colour the subtotals according to some rules (i.e. >5 in green, <2 in red). I know that this can be done in Properties -> Visual Signs, but at the moment my only result is that I coloured all the column (I used the formula TextCount ([Ragione Sociale Cliente])>=5).

what I do wrong?

14 Replies
Not applicable
Author

guys I made it! that was the correct formula

If (Dimensionality()=2 and (TextCount([Ragione Sociale Cliente])>=5), RGB(127,255,0)

,If (Dimensionality()=2 and (TextCount([Ragione Sociale Cliente])<=2), RGB(255,204,153)))

thanks anyone for your help and suggestions!

Clever_Anjos
Employee
Employee

Wouldn´t I receive a "helpful answer" too?

Not applicable
Author

I would have given it also to you, but I don't have the button...is there a limit of "helpful Answer" I can give? I have selected already two...

Not applicable
Author

ok I gave it to you the "helpful Answer"...indeed it was the turning point I need it! well done!

Clever_Anjos
Employee
Employee

Relax, just making fun