Distinguish of Year from 'MMM YYYY'

[#1]

Dear Friend,

My syntex could not distinguish year from 'MMM YYYY'  It is considering Jan 2016 is also in 2015 and so on.

I am uploading the qlik file. Kinly help.

Regards.....

[Gysbert_Wassenaar]

There's no relation between the Month and Year fields or between the Year_Actual and Year fields. The tables are only linked by Company code.

If you want the new volumes for each year for each company related to the records of the matching year then you need to create a Year field in the New_ACC table too so the tables will be linked using Company code and Year.