Discussion board where members can get started with Qlik Sense.
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.
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.
Can you attach your qvw file, so we can see what your data looks like ?
"attach qvw file"
I doubt that is going to help you as you already missed that this question is about Qlik Sense .