Discussion Board for collaboration on QlikView Scripting.
So I'm looking to merge a few intervals into a single table in QV, and I was wondering if anyone had any ideas.
Right now I have a simple table that breaks out intervals, however, a new interval is created every year if it crosses the calendar year.
I need to figure out to merge these back into single intervals. Does anyone have suggestions on where to start?
I have a table with the following structure.
I'm looking to get the following:
I have some rough ideas how to get there, but they all involve some fairly large joins and I was hoping to avoid that since the source table is several million records.
Go to Solution.
if(peek(End)+1=Start, peek(Period), autonumber(recno(),ID)) as Period
(html, codepage is 1252, embedded labels, table is @1);
LOAD ID, Date(min(Start)) as Start, Date(max(End)) as End
group by ID, Period;
drop table INPUT;
That did it. Thanks!