Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
shamitshah
Partner - Creator
Partner - Creator

Graph Issue

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

5 Replies
fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

Hope this helps.

Cheers

shamitshah
Partner - Creator
Partner - Creator
Author

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

Any ideas?

Thanks.

Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
shamitshah
Partner - Creator
Partner - Creator
Author

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.

fvelascog72
Partner - Specialist
Partner - Specialist

Hi Shamit,

Try with this

Hope helps.