topic Re: Need to get 6 weeks back data in QlikView

Need to get 6 weeks back data

vardhancse — Fri, 21 Jun 2013 06:18:37 GMT

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

Fri, 21 Jun 2013 06:41:33 GMT

try this

load * from myqvd

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

er_mohit — Fri, 21 Jun 2013 07:09:06 GMT

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