Discussion Board for collaboration on QlikView Scripting.
I have a really complex sets of analysis that doing this at the back end would save a lot of time and effort.
So, here it goes. I have two tables: one containing the values(COMPANY,END_VALUE,PERIOD_ID) and another for the periods(YEAR,QUARTER,MONTH,PERIOD_ID) joining at period_id.
try peek function. But you need to order data by COMPANY and PERIOD_ID before
Peek(END_VALUE) AS START_VALUE INLINE [
LOAD * INLINE [
and another good example using lookup() and above() functions