Compare last row and next-to-last rows

[#1]

I have data that is pre-aggregated outside of QlikView.  Each row contains a start date and an end date but the date ranges vary and I don't know when I will receive the next row of data.

I need a way to compare the last row of the table to the next-to-last row of the table, preferably in a text box.

An example qvw and associated Excel file is attached.

Thanks in advance for the help.

[rwunderlich · Accepted solution]

=FirstSortedValue(clicks, -start_period, 1)

gives you the last value,

=FirstSortedValue(clicks, -start_period, 2)

gives next to last value and so on.

-Rob

[#3]

Perfect, very simple.  Thanks.