topic Re: Transparency problems with sheet background color in QlikView

Transparency problems with sheet background color

Wed, 25 Jun 2014 07:31:52 GMT

I'm trying to use a light beige color as background, and adding some transparency to it. When I do so it actually gets darker, not brighter. Setting transparency to 100% it get light grey.

How can I change the color that seems to be behind the background color?

Kind regards

Espen

Re: Transparency problems with sheet background color

whiteline — Wed, 25 Jun 2014 08:25:50 GMT

Hi.

What is the reason to use transparency ? There is nothing to be visible behind the sheet.

Re: Transparency problems with sheet background color

Wed, 25 Jun 2014 08:51:48 GMT

The reason is that I got a color palette where for example I'm using this color: RGB(217,209,199), and then I want to use it with 40%, 55%, 70% and 85% transparency to get different shades of the same basecolor.

This is a color setup setup that I got from the client.

Kind regards

Espen

Re: Transparency problems with sheet background color

whiteline — Wed, 25 Jun 2014 09:43:43 GMT

You can use ColorMix1 function to calculate the desired color on the basis of RGB(217,209,199).

So that you can choose the secondary color whatever you want.

Re: Transparency problems with sheet background color

Wed, 25 Jun 2014 09:52:47 GMT

Thanks, that works when typing it into the expression.

Now I have to get it to work into the XML code in Themes...

It was actually easier than expected:

<Col>

</Col>

<v>ColorMix1(0,RGB(217,209,199),RGB(255,255,255))</v>

</ColorExpr>

Kind regards

Espen