topic ref line not working in QlikView

ref line not working

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all

I have tried to use add reference line in bar chart presentation tab .

but when I use expression like below

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

but its not reflecting ,

where am doing wrong?

YoussefBelloum — Mon, 05 Feb 2018 11:14:13 GMT

Hi,

the expression used here is a coloring expression, did you used on the reference line expression part ?

soniasweety — Mon, 05 Feb 2018 11:18:20 GMT

yes I used this in ref line add --- definition

I added .

YoussefBelloum — Mon, 05 Feb 2018 11:21:59 GMT

this will not work, like I said it is a color expression.

you need to define the value of your reference line before..

stabben23 — Mon, 05 Feb 2018 11:22:57 GMT

show us a snapshop of the settings in Reference lines.