Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Collor in expression

 

Hallo All,

 

 

My name is Yvon and I'm not so long working with Qlik sense so I have a question. I am having some difficulties with writing an expression.

 

would like the formula; if the value is greater than the previous month than the background collor need to be soft red.
Or if it is less than soft green.

 

Can someone help me with this expression.

 

 

BR

 

Yvon

 

3 Replies
oknotsen
Honored Contributor III

Re: Collor in expression

Hi Yvon,

Please only make a topic once. I have approved this copy, but had rejected (and deleted) your other topic in a different category.

About your question:

Not behind my work laptop right now, so I can't test this, but I am thinking along the lines of something like this:

if(SomeExpression > above(SomeExpression, ARGB(50,255,0,0), ARGB(50,0,255,0))

Put that thing in the background color box.

Of course replace "SomeExpression" by the actual expression you are using.

May you live in interesting times!
filip_duchateau
Contributor II

Re: Collor in expression

Hi Yvon,

Can you attach your qvw file, so we can see what your data looks like ?

Gr,

Filip

oknotsen
Honored Contributor III

Re: Collor in expression

"attach qvw file"

I doubt that is going to help you as you already missed that this question is about Qlik Sense .

May you live in interesting times!