Bar chart - reference lines based on two limit dates

RighettiAndrea — Sat, 16 Nov 2024 04:33:34 GMT

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!

Re: Bar chart - reference lines based on two limit dates

Vegar — Thu, 26 Sep 2019 12:34:37 GMT

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/ScriptPrefixes/IntervalMatch.htm

topic Re: Bar chart - reference lines based on two limit dates in App Development

Bar chart - reference lines based on two limit dates

Re: Bar chart - reference lines based on two limit dates