Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
RighettiAndrea
Contributor III
Contributor III

Bar chart - reference lines based on two limit dates

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:

clipboard_image_0.png

Thank you!

Labels (2)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

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...

View solution in original post

1 Reply
Vegar
MVP
MVP

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...