Qlikview Invoice Date limited to 31/12/2017

Owned by Julie Hanlon
Last updated: Nov 17, 2017
1 min read

Problem

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

Solution

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.