Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Load data based on time

Hi All,

I have attached data in my fact table and i am considering the transaction date to do incremental load.

Currently it captures the transactions from 12:00:00 AM to 11:59:59 PM . For example,If i want see the sales data for 11/29/2017 then it will be sum of all the transactions that happened  between 11/29/2017  12:00:00 AM to 11/29/2017 11:59:59 PM.

But i have a different business requirement where i need to consider the data from 8:00:00 AM to 8:00:00 AM.

In this case sales for 11/29/2017  would be the sum of transactions that occurred between 11/29/2017 8:00:00 AM to 11/30/2017  8:00:00 AM.

how can we achieve the same.

Thank you.



0 Replies