topic Re: compare current date n previous date n if greater then avoid that row in QlikView

compare current date n previous date n if greater then avoid that row

Mon, 18 Aug 2014 10:17:10 GMT

Hi All,

I want to avoid next row in script side . It means suppoase A having 22.09.2013 9:50 and B having 21.09.2013 19.00 then i want to avoid the 2 nd row of b. how to do it in script side.

Re: compare current date n previous date n if greater then avoid that row

MK_QSL — Mon, 18 Aug 2014 10:19:51 GMT

Load * From TableName

Where Date('B','DD.MM.YYYY') < Date('A','DD.MM.YYYY');

Re: compare current date n previous date n if greater then avoid that row

tresB — Mon, 18 Aug 2014 10:21:16 GMT

Try like:

Load

If(Peek('DateField')<DateField, DateField) as FilteredDate

Re: compare current date n previous date n if greater then avoid that row

Mon, 18 Aug 2014 11:02:06 GMT

NO I am having like this data:

Field Date

A 22.09.2013 9:50

B 21.09.2013 19.00

So i have to skip B row.

Re: compare current date n previous date n if greater then avoid that row

MK_QSL — Mon, 18 Aug 2014 11:06:57 GMT

Temp:

Load * Inline

[

Field, Date

A, 22.09.2013 9:50

B, 21.09.2013 19.00

];

NoConcatenate

Final:

Load

Field,

Date

Resident Temp

Where Date > Previous(Date)

Order By Date;

Drop Table Temp;