Bar chart - reference lines based on two limit dates

[RighettiAndrea]

Hi everyone,

I'm creating an app where I have a simple bar chart with the MonthName dimension on the X-axis and I want to add reference lines.

The values of these reference lines are good only for a time frame and to do this, I have in my table two columns (start-date and end-date).

So for example I have the value '100' which is good starting from the 01-jan-2018 to the 31-dec-2018 and '90' which is good starting from '01-jan-2019' to '01-sep-2019' and so on. How can I do this?

Here my X axis:

Thank you!

[Vegar · Accepted solution]

You can solve this by using intervalmatch on your star and end date against your date calendar. Take a look at this page if you're not familiar with IntervalMatch(). 

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...