Re: Sum row by date range on Load Script? [QlikSense]
Hi Bill, thanks for the reply, The reason I'm trying to set it as static data in the load script, is that I have ~ 5-6 million rows , and didn't want to overly burden the front end dynamically calculating these figures.
Is there a syntax for dimension from current cursor position vs overall range ?
Like : ( Sum ( if ( [date] < Current([date]), Amount ) )