topic Previous Billing date in QlikView https://community.qlik.com/t5/QlikView/Previous-Billing-date/m-p/1372994#M419370 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I used this in the script:-</P><P><SPAN style="color: #0000ff; font-size: 8pt;">Left</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Join</SPAN><SPAN style="font-size: 8pt;">(Fact)</SPAN><SPAN style="color: #008000; font-size: 8pt;"><BR /> </SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">LOAD</STRONG><SPAN style="font-size: 8pt;"> <BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">CustomerProductMatKey</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #008000; font-size: 8pt;"><BR /> </SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">VBRK.FKDAT</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #008000; font-size: 8pt;">, <BR /> </SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">CustomerProductMatKey</SPAN><SPAN style="font-size: 8pt;"> = </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Previous</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">CustomerProductMatKey</SPAN><SPAN style="font-size: 8pt;">)</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AND</SPAN><SPAN style="font-size: 8pt;"> (</SPAN><SPAN style="color: #800000; font-size: 8pt;">VBRK.FKDAT</SPAN><SPAN style="font-size: 8pt;"> &lt;&gt;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Previous</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[VBRK.FKDAT]</SPAN><SPAN style="font-size: 8pt;">)), </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Previous</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[VBRK.FKDAT]</SPAN><SPAN style="font-size: 8pt;">)) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">PrevBillDate</SPAN><SPAN style="font-size: 8pt;"> <BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">RESIDENT</SPAN><SPAN style="font-size: 8pt;"> Fact </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">ORDER</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">BY</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">CustomerProductMatKey</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #800000; font-size: 8pt;">VBRK.FKDAT</SPAN><SPAN style="font-size: 8pt;">; </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Previous billing date works fine but sales frequency multiplies</SPAN></P><P></P><P><SPAN style="font-size: 8pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/178178_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P><P><SPAN style="font-size: 8pt;"> Any help please</SPAN></P></BODY></HTML> Fri, 29 Sep 2017 14:33:47 GMT 2017-09-29T14:33:47Z Previous Billing date https://community.qlik.com/t5/QlikView/Previous-Billing-date/m-p/1372994#M419370 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I used this in the script:-</P><P><SPAN style="color: #0000ff; font-size: 8pt;">Left</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Join</SPAN><SPAN style="font-size: 8pt;">(Fact)</SPAN><SPAN style="color: #008000; font-size: 8pt;"><BR /> </SPAN><STRONG style=": ; color: #0000ff; font-size: 8pt;">LOAD</STRONG><SPAN style="font-size: 8pt;"> <BR /> </SPAN><SPAN style="color: #800000; font-size: 8pt;">CustomerProductMatKey</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #008000; font-size: 8pt;"><BR /> </SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">VBRK.FKDAT</SPAN><SPAN style="font-size: 8pt;">,</SPAN><SPAN style="color: #008000; font-size: 8pt;">, <BR /> </SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">CustomerProductMatKey</SPAN><SPAN style="font-size: 8pt;"> = </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Previous</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">CustomerProductMatKey</SPAN><SPAN style="font-size: 8pt;">)</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">AND</SPAN><SPAN style="font-size: 8pt;"> (</SPAN><SPAN style="color: #800000; font-size: 8pt;">VBRK.FKDAT</SPAN><SPAN style="font-size: 8pt;"> &lt;&gt;</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Previous</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[VBRK.FKDAT]</SPAN><SPAN style="font-size: 8pt;">)), </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Previous</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[VBRK.FKDAT]</SPAN><SPAN style="font-size: 8pt;">)) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">PrevBillDate</SPAN><SPAN style="font-size: 8pt;"> <BR /> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">RESIDENT</SPAN><SPAN style="font-size: 8pt;"> Fact </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">ORDER</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">BY</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">CustomerProductMatKey</SPAN><SPAN style="font-size: 8pt;">, </SPAN><SPAN style="color: #800000; font-size: 8pt;">VBRK.FKDAT</SPAN><SPAN style="font-size: 8pt;">; </SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Previous billing date works fine but sales frequency multiplies</SPAN></P><P></P><P><SPAN style="font-size: 8pt;"><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/178178_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></SPAN></P><P><SPAN style="font-size: 8pt;"> Any help please</SPAN></P></BODY></HTML> Fri, 29 Sep 2017 14:33:47 GMT https://community.qlik.com/t5/QlikView/Previous-Billing-date/m-p/1372994#M419370 2017-09-29T14:33:47Z