topic Re: Different color on pos in QlikView

Different color on pos

Fri, 14 Sep 2012 09:44:20 GMT

I wonder if someone can help me. I want bars in a chart to turn red if they are negative and green if they are positive. I have added this code "=If(Sum(Avd.) < 0, RGB(193,0,43), RGB(0,128,64))" But depending if I write "<" ">" or if I write the green RGB or the red RGD first or second I only manage to get all the bars, both positive or negative, green or red. I've tried to ad two expressions but it doesn't help. Could someone help me?

Thanks in advance.

Re: Different color on pos

rajni_batra — Fri, 14 Sep 2012 09:50:49 GMT

can u attach the app

Re: Different color on pos

Fri, 14 Sep 2012 11:29:22 GMT

Check this Attachment which I hope helps you

Re: Different color on pos

Fri, 14 Sep 2012 11:45:18 GMT

How do I just attach the app? Or more exactly, how to I extract it from the full document?

Thanks for the help.

Re: Different color on pos

Fri, 14 Sep 2012 11:46:55 GMT

I've tried to ad the code and it says it's correct (i've changed it to the colours I want), but the bars still don't get the right colours for possitive and negative...

Thanks for the help .

Re: Different color on pos

Fri, 14 Sep 2012 11:54:01 GMT

Find the Attached Document

Re: Different color on pos

Fri, 14 Sep 2012 12:06:19 GMT

I wonder if the error is between these two expressions:

//Sum(BOKFBEL*_Flagga_DriftsUtfall)/1000

sum( {$<År = {$(#vThisYear)}, Månad = {"*"}, ÅrMån = {"*"}, KoddelB_Nivå1 = {"3", "4", "5", "6", "7"}, ÅrMån = {'>= $(#vÅrMånFirst)<= $(#vÅrMånNow)'}, Ansvar = {"*"} , Avd. = {"*"} , Ansvar_Kod_Txt = {"*"} >} (BOKFBEL) *_Flagga_DriftsUtfall)/1000

=if(sum(Avd.)>0,RGB(0,128,64),if(sum(Avd.)<0,RGB(193,0,43)))

Could it be that I should write something else instead of "sum(Avd.)" in the second one? I'm from sweden so the "weird" language is Swedish.

Thanks for all the help.

Re: Different color on pos

Tue, 06 Nov 2012 07:10:54 GMT

Hello again

I got this to work with the expression =if(Utfall<Årsbudget,RGB(0,128,64),RGB(193,0,43)) but now I changed the name to "='Utfall ' & endTime" so I changed the expression to =if(='Utfall ' & endTime<Årsbudget,RGB(0,128,64),RGB(193,0,43)) but then it stopped to work. I've tried to ad and remove =, ', " and so on but it still doesn't work. Does anyone know what I've done wrong?

Thanks in advance.