Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

niccolo24
New Contributor II

conditional value color

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?

Tx

8 Replies
vgutkovsky
Honored Contributor II

Re: conditional value color

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

niccolo24
New Contributor II

Re: conditional value color

OK thanks,

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

vgutkovsky
Honored Contributor II

Re: conditional value color

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

jaimeaguilar
Valued Contributor II

Re: Re: conditional value color

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):

2014-09-08_13-46-08.png

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

Not applicable

Re: conditional value color

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

Re: conditional value color

Hi,

maybe like this?:

QlikCommunity_Thread_132417_Pic2.JPG.jpg

QlikCommunity_Thread_132417_Pic3.JPG.jpg

QlikCommunity_Thread_132417_Pic1.JPG.jpg

hope this helps

regards

Marco

niccolo24
New Contributor II

Re: conditional value color

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?

TX

niccolo24
New Contributor II

Re: conditional value color

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?

TX

Community Browser