Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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
Highlighted
MVP
MVP

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

Load * From TableName

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

Highlighted
MVP
MVP

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

Try like:

Load

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

Highlighted
Not applicable

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

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.

Highlighted
MVP
MVP

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

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;