Calculated second color gradient transparent?

[#1]

Hello,

I have a caption set to Two color graidient. I am wondering whether its possible to set the Second Color to Transparent using a calculated expression?

Regards

Marek

[flipside · Accepted solution]

Sure can - use ARGB instead of RGB and specify a value of 0 to 255 for A(alpha value) to represent the opacity.

flipside

EDIT: In your case you are looking for =ARGB(0,0,0,0).

[#3]

thanks!

thats perfect

[giakoum]

Hi flipside.

Do you have any idea how to convert a ARGB color to RGB color?

[flipside]

Yes, it IS possible, but I have only found out how to base it on a white background. Play about with the colours in the attached and you'll see what I mean.

flipside

[giakoum]

Hi Flipside.

excellent solution! This is exactly what I needed!

Please post the same solution in

http://community.qlik.com/message/345541#345541

so that I can mark it as correct.

Thank you

Ioannis

[#7]

Thank you, this app helped me a lot

[cspindley]

on behalf of the nhs thanks , the Central Informatics Team @ CUH have implemented this in an eFFICIENT & generic manner, thanX4sharing ...