topic Bar colors in QlikView

Bar colors

Wed, 20 Jan 2010 10:13:27 GMT

Dear QlikView users,

I am looking for the definition, that will allow me to show recent 12 bars in different color that rest of the bars. I know I can define color, after clicking "cross" next to my expression, but I have no idea what I should put there. Anybody knows?

Maybe another idea- Could I use bar offset to show recent 12 months?

Thank you,

Beata

Bar colors

Wed, 20 Jan 2010 10:45:38 GMT

Now I'm using:

if(Max (CalendarMonth, -12),LightGreen()) but it turns all bars green;(

Bar colors

Wed, 20 Jan 2010 11:10:34 GMT

Try this, not tested but should work


=If(CalendarMonth < (max(CalendarMonth)-12),LightGreen(), LightRed())

Should Color the first 12 Green and all the Others Red, cahnge Colors to your needs 😉 (I prefeer Using the rgb() function becasue you're more flexible!)

Edit:
Here a suggestion for Baroffset (looks nice in Combination with the Colors)

Just paste in the "Baroffset" Part:


=If(CalendarMonth < (max(CalendarMonth)-12),1,0)

Greets

Bar colors

Wed, 20 Jan 2010 11:11:20 GMT

I accidantly suggested your post as answer, just ignore that...

Bar colors

Wed, 20 Jan 2010 11:17:35 GMT

Hi,

In the same place (by clicking "cross" next to the expression -> Background Color) try to write this:

IF(Date>$(=chr(39)&addmonths(max(Date),-12)&chr(39)),lightgreen(),blue()).

Instead of my "Date" field use yours.

Bar colors

Wed, 20 Jan 2010 11:35:02 GMT

This should work fine for you:

IF(makedate(CalendarYear,CalendarMonth)>$(=chr(39)&addmonths(max(makedate(CalendarYear,CalendarMonth)),-12)&chr(39)),lightgreen(),blue())

Instead of "Date" field i wrote "makedate(CalendarYear,CalendarMonth)"

Bar colors

Wed, 20 Jan 2010 16:14:14 GMT

Hello Jusitia,

Unfortunately it doesn't work - everything turns to red. Fortunately expression suggested by Milda works perfectly. Could you elaborate more on bar offset option? Do you have another examples? Thank you very much!

greetings,

Beata

Bar colors

Wed, 20 Jan 2010 16:16:05 GMT

Hi Milda,

It works great! Could you tell me more what chr(39) means? I think I saw it somewhere and I suppose it would be good if I can use it alone;)

Thank you very much,

Grtz,

Beata

Bar colors

Wed, 20 Jan 2010 16:49:02 GMT

I'm sorry for that. I forgot to mention that this is just the basic Idea how it works, Milda did a great Job coding it right for your case! Now you can use this Statement for the bar offset as well. (I try to make this one correct)


IF(makedate(CalendarYear,CalendarMonth)>$(=chr(39)&addmonths(max(makedate(CalendarYear,CalendarMonth)),-12)&chr(39)),1,0)

What I've done is simply replacing the colors with 1 and 0 (1 for Offset and 0 for no Offset).

One Tip from me: Offset doesnt look great and also decreases the charts readability, I suggest using the "Show Value" 2 lines below "Bar offset". The statement is the same as above!

Edit: Please let me know if "Show vale" and/or "bar offset" worked and give Milda the "Verified Answer"

Greets

Bar colors

Thu, 21 Jan 2010 07:51:58 GMT

Hi Beata,

function chr() is used for making some symbols. In this case chr(39) means ' (quates).

All symbols with their codes you can find on www.LookupTables.com.

Bar colors

Thu, 21 Jan 2010 08:00:10 GMT

Sorry, I gave you the wrong address. This is the right one:

http://www.asciitable.com/