Qlikview Invoice Date limited to 31/12/2017

Problem

QlikView sales analysis is not picking up invoices dated after 31/12/2017.

In the Model,

File> Edit Script> Choose the Main Tab.

Find the line that is now green in my screen shot below. Put the two //’s in the front.

//let NumOfDays=(yearend(today())-'$(FirstTransDate)');

And then put the line below, below.

let NumOfDays=floor((monthend(today(),12)-'$(FirstTransDate)'));

then choose OK, save the model on the main ribbon, the one on the LHJS of the print icon is good, then refresh and have a test.