topic Re: Multiple Dimensions In Bar Chart, conditional coloring in QlikView

Multiple Dimensions In Bar Chart, conditional coloring

chrweber — Mon, 11 Jun 2018 13:54:23 GMT

Hi,

I have a bar chart with two dimension,

the second dimension contains values e.g. 8 and 9.

I have a scenario where I have one bar for each.

Now I wish to use the same color but different transparencies:

=Red($(=if([BogusAuxDim] = 8, 125, 255)))

But this does not evaluate, what am I missing?

Best Regards

kfoudhaily — Mon, 11 Jun 2018 14:17:22 GMT

i suggest:

=if([BogusAuxDim] = 8, rgb(255,0,0),rgb(255,100,100))

regards,

jwjackso — Mon, 11 Jun 2018 14:19:21 GMT

=If([BogusAuxDim] = 8,Red(125),Red(255)

chrweber — Wed, 13 Jun 2018 05:05:48 GMT

Hi,

unfortunately this answer does not include transparency, which is what this question is about

chrweber — Wed, 13 Jun 2018 05:08:35 GMT

Interestingly, this works and it allows the execution of my original intend:

=If([BogusAuxDim] = 8,White(125),White(255) bitand Red()

However I would still like an explanation why the other expression fails

jonathandienst — Wed, 13 Jun 2018 05:11:22 GMT

You almost had it, but you dont need a $ expansion:

=Red(if([BogusAuxDim] = 8, 125, 255))

chrweber — Wed, 13 Jun 2018 05:30:56 GMT

Well, that is just my problem.

I tried that, of course but then I get default colors.

The expression fails silently