Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=FirstSortedValue(clicks, -start_period, 1)
gives you the last value,
=FirstSortedValue(clicks, -start_period, 2)
gives next to last value and so on.
-Rob
=FirstSortedValue(clicks, -start_period, 1)
gives you the last value,
=FirstSortedValue(clicks, -start_period, 2)
gives next to last value and so on.
-Rob
Perfect, very simple. Thanks.