topic Re: Remove outdated data in QlikView

Remove outdated data

Wed, 02 Apr 2014 13:49:54 GMT

Hi Qlikview Developers,

I have a data set dating back to 2011 which I only want to upload the most recent date. How do remove data from Sept 2013 and back by using a script? Below is the script but it is not working. Please advise.

Here's the script:

if((Period_End_Date)>9/30/2013,date(date#(left(Period_End_Date, 10),'MM/DD/YYYY'),'MMM-YYYY'), Period_End_Date)as Period_End_Date

Thank you.

Jasmine

Re: Remove outdated data

MK_QSL — Wed, 02 Apr 2014 13:52:33 GMT

You can do something like below in script..

Load

Field1,

Field2

....

From TableName

Where Period_End_Date > Date#(FLOOR(Period_End_Date),'M/D/YYYY');

Re: Remove outdated data

Gysbert_Wassenaar — Wed, 02 Apr 2014 13:56:21 GMT

If you want to load only data newer than 9/30/2013 you can use a where clause:

MyData:

Load * from MySource

Where Period_End_Date > '9/30/2013'

You may have to use the date# and/or date functions to pass the value in the correct date format.

Re: Remove outdated data

Wed, 02 Apr 2014 14:05:49 GMT

Hi,

Thank you for your quick response. I used (Where Period_End_Date > '9/30/2013') and return just Sep-2013 data. Is there a way to show Sep-2013 and onward data?

Thanks,

Jasmine

Re: Remove outdated data

Gysbert_Wassenaar — Wed, 02 Apr 2014 14:12:26 GMT

The where clause you used should load the data from October 2013 and later. If it shows data from September 2013 only then the where clause is not working. That probably means the date format is not correct. Without seeing the actual data I cannot tell what would be the right date format.