Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
OK thanks,
but how do i set this only for the current month? what is the formula?
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
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
=if(Month(Date)=Month(Now()) and Year(Date)=Year(now()), Blue())
Hi,
maybe like this?:
hope this helps
regards
Marco
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
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