Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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.


Regards,

Viresh

0 Replies