Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
niccolo24
Contributor II
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
Master II
Master II

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
Contributor II
Contributor II
Author

OK thanks,

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

vgutkovsky
Master II
Master II

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
Partner
Partner

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

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

MarcoWedel

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
Contributor II
Contributor II
Author

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
Contributor II
Contributor II
Author

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