topic Re: How to find previous and next record from a table? in QlikView

How to find previous and next record from a table?

Thu, 25 Aug 2011 09:08:03 GMT

Hi....

Suppose I have a tbale with dates..

I want a table with following columns...

I want Previous and next record of each rows.

Thanks in advance...

Satish

swuehl — Thu, 25 Aug 2011 09:11:47 GMT

I think you can use the interrecord functions: above and below:

=above(Date)

resp.

=below(Date)

as expressions for Previous Date and Next Date with dimension Date.

Regards,

Stefan

Thu, 25 Aug 2011 09:26:37 GMT

I have to use those Previous Date and Next Date fields in Some calculations.

So I need those fields only in script part. I also used Previous and peek functions.

But value I am getting is not right.

Regards,

Satish.

its_anandrjs — Thu, 25 Aug 2011 09:28:36 GMT

Hi,

Yes right you need to use the Above and Below fuctions for the date view for the Previous Date and Next Date put Above(Date) , Below(Date).

See the attached sample for clearing your problems.

Regards

Anand

swuehl — Thu, 25 Aug 2011 09:37:50 GMT

If you want to create that table in script, you might use something like:

Left Join Load *,

peek(Date) as NextDate

resident Dates order by Date desc;

Left Join Load *,

peek(Date) as PreviousDate

resident Dates order by Date ASC;

Where Dates is your calendar table with field Date.