topic Re: Background Color Expression in App Development

Background Color Expression

sspawar88 — Wed, 27 May 2015 15:00:03 GMT

Hi,

Suppose My set analysis expression is too large. it contains Too many conditions. i could not able to plot Color() in Expression.

and Result of all expression is in Between 1 to 100.

How Can I get following without using whole Expression in 'Background Color Expression'

a) <51--> Red(),

b)Between 51 to 70--> Yellow(),

c) >71--> Green()

New to Qlik Sense‌

Background color and Set Analysis‌

Qlik Sense Resource Library‌

App Development‌

Re: Background Color Expression

rubenmarin — Wed, 27 May 2015 15:08:35 GMT

Hi Satish, you can use expression name in BgColor expression, if your expression caption is 'Expr1', you can use:

If(Expr1<51, Red(),

If(Expr1>71, Green(), Yellow()))

Re: Background Color Expression

sunny_talwar — Wed, 27 May 2015 15:12:03 GMT

Not sure how it works in Qlik Sense, but in QlikView you can use the Label of the expression to achieve what you are aiming for:

For example if the label of your expression is TotalSales, then you can use the following for 'Background Color Expression'

If(TotalSales < 51, Red(), If(TotalSales < 70, Yellow(), Green()))

I would think that Qlik Sense should allow for the use of expression label or Column() function.

HTH

Best,

Sunny

Re: Background Color Expression

sspawar88 — Wed, 27 May 2015 15:24:48 GMT

Hi Ruben,

My Expression label is %Compliance...But its not working in Background color Expression.

My expression result is in 34%, 48%

i used following expression

If(%Compliance < 51, Red(),

If(%Compliance > 71, Green(), Yellow()))

also

If(%Compliance < 51%, Red(),

If(%Compliance > 71%, Green(), Yellow()))

But its not working

Re: Background Color Expression

rubenmarin — Wed, 27 May 2015 15:27:01 GMT

Whoops, I didn't see this was for Sense, I gave a QlikView answer, not a Sense answer.

Just to be sure if this works on Sense, can you try?:

If([%Compliance] < 51, Red(),

If([%Compliance] > 71, Green(), Yellow()))

Re: Background Color Expression

rubenmarin — Wed, 27 May 2015 15:31:27 GMT

Already tried in Sense and works with column label, the '%' should be messing with the interpretation of Column label

Re: Background Color Expression

sunny_talwar — Wed, 27 May 2015 15:32:56 GMT

May be use Column() function if label is tricky although the square brackets should fix it

Re: Background Color Expression

sspawar88 — Thu, 28 May 2015 03:54:59 GMT

No its not working.

can you have any other Solution?

Re: Background Color Expression

sspawar88 — Thu, 28 May 2015 03:58:22 GMT

Can you please explain it how to use Column() here in my scenario?

Re: Background Color Expression

rubenmarin — Thu, 28 May 2015 09:13:21 GMT

Hi Satish, I made a sample with Sense using the same column label and it's working, please check attachment and tell us what's different in your document or if there is something I missunderstood.