Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Previous Billing date

Hi,

I used this in the script:-

Left Join(Fact)
LOAD
CustomerProductMatKey,
VBRK.FKDAT,,
if(CustomerProductMatKey = Previous(CustomerProductMatKey)AND (VBRK.FKDAT <>Previous([VBRK.FKDAT])), Previous([VBRK.FKDAT])) as PrevBillDate
RESIDENT Fact ORDER BY CustomerProductMatKey, VBRK.FKDAT;

Previous billing date works fine but sales frequency multiplies

Any help please

0 Replies