topic Re: Graph Issue in QlikView

Graph Issue

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

Hi,

Please see attached. There are three issues that I am trying to solve:

1) I want to stop the Curr Yr Actuals YTD line extending beyond June 2017. It is currently extending beyond the current year.

2) I want to include a cumulative to date Actuals line starting in Jan 2017 (the value in Jan 2017 being Full Year Actuals 2016 + Actuals for Jan 2017 = 1235) and then extend out to June 2017 ( the value being 2610).

3) Need a vertical reference line separating the years.

Appreciate your assistance.

Thanks

Re: Graph Issue

fvelascog72 — Thu, 29 Jun 2017 10:54:53 GMT

Hi,

Hope this helps.

Cheers

Re: Graph Issue

shamitshah — Fri, 30 Jun 2017 01:44:35 GMT

Hi Federico,

Thanks for the info. I have used parts of your solution.

I am still struggling with the Curr Yr 2017 YTD Actual line to end in 2017 Dec. It is extending out in 2018.

Any ideas?

Thanks.

Re: Graph Issue

Anil_Babu_Samineni — Fri, 30 Jun 2017 02:51:25 GMT

What was the expression you used for CY 2017 YTD??

Re: Graph Issue

shamitshah — Fri, 30 Jun 2017 04:37:42 GMT

That was used to calculate the year to date figures for the Current Financial Year i.e. 2017. This period runs from 1 Jan 2017 to 31 Dec 2017.

Re: Graph Issue

fvelascog72 — Fri, 30 Jun 2017 05:27:38 GMT

Hi Shamit,

Try with this

Hope helps.