writing set expression in load script

lalprasanth — Sat, 16 Nov 2024 04:39:17 GMT

Hi guys,

I need the following set expression to be written in the load script so that it get optimized

Sum(
aggr( if(house_date=date(today()),sum({<ref_date={"$(=date(lastworkdate(today(),1)))"}>}Stock * $(vfilter5)),
RangeMax(sum({<idDate={1}>}aggr(stock_Forecast * $(vfilter5bis),key_OA))
-sum(aggr(avg_forecast* $(vfilter5bis) ,key_OA)),0)),[Nivpe 1 - Enseigne],LB_LEV_2,[Nivpe - Entrep],op_Forecast))

Could you please help me out on this..

Re: writing set expression in load script

Gysbert_Wassenaar — Sun, 27 Jan 2019 08:40:10 GMT

You cannot use the Aggr function in the script and neither can you use set analysis expressions. You'll have to create tables to collect the values you need to calculate any results and intermediate results. If the variables you use contain expressions then you need to calculate those values first too, probably in more intermediate tables.

topic writing set expression in load script in QlikView

writing set expression in load script

Re: writing set expression in load script