Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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.

4 Replies
MK_QSL
MVP
MVP

Load * From TableName

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

tresesco
MVP
MVP

Try like:

Load

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

Not applicable
Author

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.

MK_QSL
MVP
MVP

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;