topic Re: Transparency function in QlikView

Transparency function

danialier — Thu, 06 Mar 2014 12:30:27 GMT

Hello,

In a text box, under Font tab, under Color, which is the formula I should use in calculated field to make the text box with 100% transparency based on a specific selection ?

For instance, in order to make the text box as white I need to enter white() or in red it should be red(). However if I want the text box to be let's say red and with 50% transparency what should I add on top of red() ?

thks,dani

Re: Transparency function

maxgro — Thu, 06 Mar 2014 12:34:51 GMT

if i'm not wrong from 0 to 255

red(128)

or you can use argb

from online help

ARGB(alpha, e1, e2, e3)

This function returns the color representation of a color defined by the red component e1, the green component e2 and the blue component e3 with an alpha factor (opacity) of alpha. All four parameters must be expressions evaluating to integers in the range between 0 and 255. The color representation is a dual value where the text representation comes in the form of 'RGB(a,r, g, b)' where a, r, g and b are numbers between 0 and 255 representing the alpha, red, green and blue color value respectively. The number representation is an integer representing the alpha, red, green and blue components as defined in Visual Basic

Re: Transparency function

rustyfishbones — Thu, 06 Mar 2014 12:44:23 GMT

You can add the Alpha value between the parenthesis

RED(128)

WHITE(128)

Re: Transparency function

MK_QSL — Thu, 06 Mar 2014 13:07:58 GMT

Like this..