topic Re: conditional value color in QlikView

conditional value color

Anonymous — Mon, 08 Sep 2014 18:14:23 GMT

HI,

I need to color in a different way (more transparancy for example), the value of the current month (dimension is month).

Attached is a screenshot.

How can I do this?

Re: conditional value color

vgutkovsky — Mon, 08 Sep 2014 18:26:00 GMT

You can achieve more transparency using ARBG instead of the regular RGB function. For example, try to create a text object with background color rgb(63,72,204) versus one with color argb(100,63,72,204).

As far as applying the condition to the bar itself, use the + sign that's next to the expression, and set the color formula on the "Background Color" expression.

Regards,

Vlad

Re: conditional value color

Anonymous — Mon, 08 Sep 2014 18:33:32 GMT

OK thanks,

but how do i set this only for the current month? what is the formula?

Re: conditional value color

vgutkovsky — Mon, 08 Sep 2014 18:36:29 GMT

Well, there are a lot of ways to define "current" (e.g. last data date, previous month end, etc), but I'm assuming you mean literally the current (i.e. today). That would be something like: if(Month=month(today()),argb(100,63,72,204),rgb(63,72,204))

Regards,

Vlad

Re: Re: conditional value color

jaimeaguilar — Mon, 08 Sep 2014 18:48:53 GMT

Hi,

check the attached example. By using the ARGB() function you can control the transparency (alpha) of the color(s) you are using.

You can modify it in the expression tab (in the background color option):

In the example I used Monthname as dimension, but it can be any time dimension and it should work. You can use and if to tell QlikView to change the transparency if the month is the current month,

regards

Re: conditional value color

Mon, 08 Sep 2014 18:53:04 GMT

=if(Month(Date)=Month(Now()) and Year(Date)=Year(now()), Blue())

Re: conditional value color

MarcoWedel — Mon, 08 Sep 2014 20:20:41 GMT

Hi,

maybe like this?:

hope this helps

regards

Marco

Re: conditional value color

Anonymous — Tue, 09 Sep 2014 08:45:06 GMT

Tx that is great. Now what if in thist chart i have a drill down on dimensions that works like this, and I have linked a table with a RGB dimension to each product level

Product level 1 -> RGB_PDTColor1

Product lvl 2 -> RGB_PDTColor2

Product lvl 3 -> RGB_PDTColor3

Product lvl 4 -> RGB_PDTColor4

How can I associate a different color through the drilldown. And how can I integrate the ARGB() for the current month?

Re: conditional value color

Anonymous — Tue, 09 Sep 2014 09:58:08 GMT

Tx that is great. Now what if in thist chart i have a drill down on dimensions that works like this, and I have linked a table with a RGB dimension to each product level

Product level 1 -> RGB_PDTColor1

Product lvl 2 -> RGB_PDTColor2

Product lvl 3 -> RGB_PDTColor3

Product lvl 4 -> RGB_PDTColor4

How can I associate a different color through the drilldown. And how can I integrate the ARGB() for the current month?