topic Re: Color in bar chart depending on dimension value in QlikView

Color in bar chart depending on dimension value

Tue, 10 Jun 2014 06:57:55 GMT

Hi guys!

I have a bar chart displaying the value of the order and the dimension is the delivery week.

So, i have on the chart the orders scheduled for week 20, 21, 22... (as you can see in the attached picture).

Here is the problem!!!

I want to color differently the bar, depending on the delivery week.

I explain better. Suppose we are in week 24.

I would like to:

1) the bar of previous weeks (23, 22, 21 and behind) are in black color,

2) the bar of our current week is red,

3) the bar of future weeks (25, 26, 27...) are in green color.

I thought to use the color function of the expression but I don't know how to get the x value, i.e. the delivery week.

Which function should I use?

Is there a more correct way?

Hope you can help me!!!

Thanks in advance!!!

Re: Color in bar chart depending on dimension value

tresB — Tue, 10 Jun 2014 07:06:29 GMT

Could you post your sample app?

You could try like:= If(Week(Today())>[Delivery Week], Green(), If(Week(Today())=[Delivery Week],Red(),Black()))

Re: Color in bar chart depending on dimension value

Tue, 10 Jun 2014 07:31:11 GMT

Easier than I suppose!!! It works!!!

Thanks tresesco!!!

Re: Color in bar chart depending on dimension value

Tue, 10 Jun 2014 08:03:33 GMT

I thank you too soon! Your answer is correct but I got another problem!

In the chart I have an expression with set analysis which ignore (override) the user selection.

But if statement consider the selection, so the colors change even if they should not!!!

How can I ignore the selection with the if statement?

Re: Color in bar chart depending on dimension value

tresB — Tue, 10 Jun 2014 08:09:27 GMT

try like:

=Only( {your set} If(....))

Re: Color in bar chart depending on dimension value

Tue, 10 Jun 2014 08:20:41 GMT

Made my day!!! It works!!!

But could you explain me briefly the "only" function?

Re: Color in bar chart depending on dimension value

tresB — Tue, 10 Jun 2014 08:25:28 GMT

Only is an aggregation function (note: set analysis can be used only in aggregation functions) that returns a value if there is only one value in the scope otherwise returns a null. I took only() to take just the advantage of set analysis.