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: 
vardhancse
Specialist III
Specialist III

Need to get 6 weeks back data

Hi All,

Curenntly I have a requirement is that I have a huge voume of data i.e around 3 years of data.

In that I want to create QVD for last 6 weeks data.

Can any one help me out in creating the expression for the same.

Thanks & Regards

Sasi

2 Replies
Not applicable

try this

load * from myqvd

where week(date(datefield)) >=week(max(date(datefield))) -6 and week(date(datefield)) <=week(max(date(datefield)))

er_mohit
Master II
Master II

Master:

load * from qvd;

noconcatenate

Transaction:

load *

resident Master

Where week(TempDate)<= Week(Date(Today()))-6 ORDER BY TempDate ASC;

drop table Master;  //if you want then drop it

store Transaction  into E:\tansaction.qvd;

here bold one is My Date Field

hope it helps