Hello everyone, In qliksense, In the script editor, I need to select for each order the first date that is followed by at least two other consecutive dates. I have table like this:
I think I would add a flag to the first table using Previous(), and create the result table based on that. Add a column (using join and resident load from the same table) where you check if previous(date) is the previous month - if it is set the flag to 1, otherwise to 0. After this you create a temporary table where you sum the flag field per the order field - all "order" with a value of at least 3 are those that you are looking for. Use those orders to check for min(date) and there's your answer.
Something like that, unforutnately I don't have time right now to write code sample.
left join(table1) load order, date, if(previous(monthstart(date))=monthstart(date) resident table1 order by order, date desc;
