Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
Go to Solution.
=FirstSortedValue(clicks, -start_period, 1)
gives you the last value,
=FirstSortedValue(clicks, -start_period, 2)
gives next to last value and so on.
Perfect, very simple. Thanks.