App Development

Discuss and learn more about Qlik Sense app development and usage.

Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.

Who Me Too'd this topic

gprejlek
Contributor
Contributor

Line graph Conditional reference line

Hi,

I need som help. I would like to create a a lower limit reference line which value is depends on date. (you see on the bottom a green line changes from -0.7 to -0.8 but it is not a reference line it is a measure it this case).image.png

 

I tried with the next expression but it not works.

=if([Full date])<date#('2021-02-19', 'YYYY-MM-DD'),-0.7,if([Full date]>=date#('2021-02-19', 'YYYY-MM-DD'),-0.8,2))

 

Could anyone help how to change the expression?

Labels (3)
Who Me Too'd this topic