Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2017-09-29 10:33 AM

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

Labels (1)
Labels
350 Views
0 Likes
0 Replies