topic Re: How change a color in a dynamic expression in QlikView

How change a color in a dynamic expression

pascos88 — Thu, 26 Nov 2015 09:33:05 GMT

I need to change color in a bar chart that have this expression.

=(if(vView='MWh' and vTime='Month', Only (MonthProd), if(vView='MWh' and vTime='Year',Only(YearProd),

if(vView='Revenue' and vTime='Month', Only (MonthRevenue), if(vView='Revenue' and vTime='Year',Only(YearRevenue),

if(vView='Opex' and vTime='Month', Only (MonthOpex), if(vView='Opex' and vTime='Year',Only(YearOpex))))))))

vView and vTime are variables.

where MonthProd, YearProd.. etc are all different expression.

this is my chart and I want that the bar chart change color(Red) when the value is < 0 for example.

thanks

Pasquale

Re: How change a color in a dynamic expression

buzzy996 — Thu, 26 Nov 2015 09:45:54 GMT

try with ur expression like below.

Re: How change a color in a dynamic expression

Anonymous — Thu, 26 Nov 2015 09:53:23 GMT

Hello,

in your chart, go to colors tab, select the first colour of the list and change the base color by a calculated one:

if(sum(sales) >0, green(), red())

Re: How change a color in a dynamic expression

morganaaron — Thu, 26 Nov 2015 09:58:40 GMT

If this is all one expression, you should be able to reference the expressions name in the background color attribute - so If([Your Expression Name] < 0, Red(),) for example.

Re: How change a color in a dynamic expression

Thu, 26 Nov 2015 10:09:03 GMT

Hi PasCos88

First give a label name to your Expression like

Next write the following condition based on the above label name

Re: How change a color in a dynamic expression

pascos88 — Thu, 26 Nov 2015 10:16:09 GMT

Thanks all for the quick reply.

It is work well really thanks.

If some one can help me again, I have another problem.

I need to return 2 expression in one if condition.

i.e

if(vVariable = 'Yes', Only(A) and Only(B), if(vVariable='No', Only(C) and Only(D)))

A and B or C and D will be show like a bar in the same chart.

Thanks for replay

Pasquale

Re: How change a color in a dynamic expression

Thu, 26 Nov 2015 10:23:03 GMT

Hi pasquale,

Refer Schreen shot to get the colring for your expression

Re: How change a color in a dynamic expression

reddy-s — Thu, 26 Nov 2015 10:37:25 GMT

Hi Pasquale Cosimato

If you have to colour code based on other measures which are not being used in a visualization, you can make use of the colour mix wizad from the expression editor screen as well. This will help you build complex colours expressions with ease.

Check this out : Qlikview ColorMix Wizard

Re: How change a color in a dynamic expression

reddy-s — Thu, 26 Nov 2015 10:46:45 GMT

Hi Pasquale,

I am assuming that this is a measure. If so, it would be easy if you use set analysis

For example: if(vVariable = 'Yes',sum({$< company = {'A','B'}>}sales), if(vVariable='No', sum({$< company = {'C','D'}>}sales)

Re: How change a color in a dynamic expression

pascos88 — Thu, 26 Nov 2015 11:08:14 GMT

is possible return 2 expression in one if condition?

thanks Sangram with your replay.

Maybe here you can better understand what I looking for.

A B C D are the expression that I want show in a chart if I have a particolar condition