Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ppl ,
Load Shop_id,city, min(orderdate) as start_date, max(orderdate) as end_date
Resident orders_table
group by shop_id,city;
this load is taking half an hour can you people help me to reduce the load time its has 50 million records.
Thanks in advance.
May be using a for loop with this https://qlikviewcookbook.com/2015/05/better-calendar-scripts/