topic Re: Dynamic opacity in ARGB() for table background color. in QlikView

Dynamic opacity in ARGB() for table background color.

Thu, 11 Sep 2014 15:07:49 GMT

Hello --

I'm attempting to change the background color of a table chart depending on how poor the dimension is performing. I calculate the opacity of the ARGB() function by simply multiplying the percent change by 1000. So if the dimension is performing 6% under from the year before the ARGB call would look like this: ARGB(60, 255, 0, 0). I've played around with the function to make sure ridiculous numbers don't break it so ARGB(255, 255, 0, 0) works as well as ARGB(400000, 255, 0, 0).

Anyhow, it doesn't seem that putting the value in a field translates to a number ARGB() can use. My function: =If(change_percent <= 0, ARGB(opacity, 255, 0, 0)) that is behind the 'Background Color' doesn't work. I've tried typecasting using Num() but that doesn't help. Any suggestions?

Attached is an example.

Thanks,

Hudnutt

Re: Dynamic opacity in ARGB() for table background color.

antoniotiman — Thu, 11 Sep 2014 15:28:49 GMT

Hi Dave,

have You tried to use Wizard of ColorMix1 or ColorMix2 ?

Regards,

Antonio

Re: Dynamic opacity in ARGB() for table background color.

Thu, 11 Sep 2014 15:31:33 GMT

I don't even know of such a thing. I'll look into it.

Re: Dynamic opacity in ARGB() for table background color.

antoniotiman — Thu, 11 Sep 2014 15:33:57 GMT

In background color -> File -> Wizard.

Re: Dynamic opacity in ARGB() for table background color.

ThornOfCrowns — Thu, 11 Sep 2014 15:34:44 GMT

You need to have a positive value in the A of ARGB, so muliply your opacity by -1:

=If(change_percent <= 0, ARGB(opacity*-1, 255, 0, 0))