topic Set interval value with colors in QlikView

Set interval value with colors

Thu, 12 Jun 2014 13:24:44 GMT

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?

Re: Set interval value with colors

Clever_Anjos — Thu, 12 Jun 2014 13:28:02 GMT

Use Color background of Expression tab.

There´s a small right beside your expression

Re: Set interval value with colors

Anonymous — Thu, 12 Jun 2014 13:28:41 GMT

Go to Expressions(Yours)->Text Color->Create a new expression->If(your expression>5,Green(),If(yourexpression<2,Red()))

try this and let me know

Re: Set interval value with colors

alexandros17 — Thu, 12 Jun 2014 13:29:30 GMT

Ciao Irene,

select the expression, then click on icon and write in text color (or background color) textbox:

If(TextCount ([Ragione Sociale Cliente])>=5, RGB(20,20,20),

If(TextCount ([Ragione Sociale Cliente])<5, RGB(220,220,220),

rgb(255,255,255)

)

Let me know

Re: Set interval value with colors

Thu, 12 Jun 2014 13:31:18 GMT

I don't understand what are you referring to...in which folder you are? Visual Signs?

Re: Set interval value with colors

Thu, 12 Jun 2014 13:34:16 GMT

I understood...I'm trying now...

Re: Set interval value with colors

Clever_Anjos — Thu, 12 Jun 2014 13:39:17 GMT

Expressions Folder

Re: Set interval value with colors

Thu, 12 Jun 2014 13:43:55 GMT

Alessandro Saccone your answer is partially correct considering what I need...I should be able to highlight ONLY the subtotals, NOT all the numbers that respect the criteria. As you can see in the file attached, I selected only the totals...do you know if it is possible something like that?

Re: Set interval value with colors

Clever_Anjos — Thu, 12 Jun 2014 13:46:36 GMT

Combine with expression using Dimentionality() function that returns which level you are

ex.:

IF (Dimentionality() =2 and value>2, red())

Re: Set interval value with colors

Thu, 12 Jun 2014 13:59:26 GMT

I wrote this formula

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

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

but the result is that are colored all and ONLY the subtotals=1 with this color RGB(127,255,0)...what I type wrong?

Re: Set interval value with colors

Thu, 12 Jun 2014 14:07:09 GMT

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!

Re: Set interval value with colors

Clever_Anjos — Thu, 12 Jun 2014 14:10:32 GMT

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

Re: Set interval value with colors

Thu, 12 Jun 2014 14:12:58 GMT

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...

Re: Set interval value with colors

Thu, 12 Jun 2014 14:14:24 GMT

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

Re: Set interval value with colors

Clever_Anjos — Thu, 12 Jun 2014 14:22:01 GMT

Relax, just making fun