topic rangesum in script in QlikView https://community.qlik.com/t5/QlikView/rangesum-in-script/m-p/197315#M57029 <HTML><HEAD></HEAD><BODY><P></P><P>Hi</P><P></P><P>How can i transform this expression to be used in the script?</P><P>Thi thing i want to create is a R12 average of DPO_Weighted_Days_Total per YearMonth</P><P></P><P>if((rangesum(Above(sum({1&lt;Supplier_DWID={Total}, Year=, Month=&gt;}Counter_YearMonth),0,12)))=12,</P><P>rangesum(Above(sum({1&lt;Supplier_DWID={Total}, Year=, Month=&gt;}DPO_Weighted_Days_Total),0,12))</P><P>/12)</P><BR /><BR /></BODY></HTML> Tue, 05 Apr 2011 08:44:45 GMT jakob_hansen 2011-04-05T08:44:45Z rangesum in script https://community.qlik.com/t5/QlikView/rangesum-in-script/m-p/197315#M57029 <HTML><HEAD></HEAD><BODY><P></P><P>Hi</P><P></P><P>How can i transform this expression to be used in the script?</P><P>Thi thing i want to create is a R12 average of DPO_Weighted_Days_Total per YearMonth</P><P></P><P>if((rangesum(Above(sum({1&lt;Supplier_DWID={Total}, Year=, Month=&gt;}Counter_YearMonth),0,12)))=12,</P><P>rangesum(Above(sum({1&lt;Supplier_DWID={Total}, Year=, Month=&gt;}DPO_Weighted_Days_Total),0,12))</P><P>/12)</P><BR /><BR /></BODY></HTML> Tue, 05 Apr 2011 08:44:45 GMT https://community.qlik.com/t5/QlikView/rangesum-in-script/m-p/197315#M57029 jakob_hansen 2011-04-05T08:44:45Z