Sample for Finance Actual vs Forecast chart in QlikView

    Please find the attached qvw.

     

    Note:

         It is a simple sample document

         The test data is only for FY 18

         In the chart object shows either actual or forecast. (If there is any data for actual, shows actual data otherwise it shows forecast)

         in the calendar tab in load script generate Calendar dimension with Month, Year and FYYear.

             

    Hopefully it helps you.