Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
markp201
Creator III
Creator III

Daily fact table loads...

What is best/recommended method to handle loading facts from day to day?

For example, orders and order detail is loaded for a customer but the next day there are no new orders and we want to trend order activity from day to day.

I don't want to duplicate all the old facts again but we want to see the trend "flatline"

If one day I get 100 new orders I want to see that spike in the trendline.

3 Replies
swuehl
MVP
MVP

Shouldn't this be done by tracking something like 'OrderDate'?

Or maybe I just don't understand what you are after and how your data looks like...

swuehl
MVP
MVP

Maybe you are looking for something like an Incremental LOAD approach?

Using QVD files for incremental load ‒ QlikView

stabben23
Partner - Master
Partner - Master

Hi,

I should be supriced if the ordertabel dont contain some kind of status on the order. You should here see when (date) the status is changed on every order.