topic Re: Equivalent to Analytical function of oracle Syntax at script level in QlikView https://community.qlik.com/t5/QlikView/Equivalent-to-Analytical-function-of-oracle-Syntax-at-script/m-p/104614#M603119 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>And if you try in your preceding load statement :</P><P></P><P>load </P><P>sum(sal),</P><P>Dptno</P><P>resident SALES</P><P>group by Dptno ;</P></BODY></HTML> Mon, 15 Oct 2018 11:02:11 GMT sergio0592 2018-10-15T11:02:11Z Equivalent to Analytical function of oracle Syntax at script level https://community.qlik.com/t5/QlikView/Equivalent-to-Analytical-function-of-oracle-Syntax-at-script/m-p/104613#M603118 <HTML><HEAD></HEAD><BODY><P>Hi All ,</P><P></P><P>I have data at location,item and at day grain but in Ui i have to show the region average and loop and reduce at location level.</P><P>but when we are going to loop and reduce at location level , i cannot calculate the region average , thats need to be done at script level.</P><P></P><P>Do we have any function at script level that we can aggregate the value at region level for e.g in oracle we can use analytical function like <SPAN style="font-size: 13.3333px;">SUM(sal) OVER (PARTITION BY deptno) </SPAN></P></BODY></HTML> Mon, 15 Oct 2018 10:45:21 GMT https://community.qlik.com/t5/QlikView/Equivalent-to-Analytical-function-of-oracle-Syntax-at-script/m-p/104613#M603118 sunil1989 2018-10-15T10:45:21Z Re: Equivalent to Analytical function of oracle Syntax at script level https://community.qlik.com/t5/QlikView/Equivalent-to-Analytical-function-of-oracle-Syntax-at-script/m-p/104614#M603119 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>And if you try in your preceding load statement :</P><P></P><P>load </P><P>sum(sal),</P><P>Dptno</P><P>resident SALES</P><P>group by Dptno ;</P></BODY></HTML> Mon, 15 Oct 2018 11:02:11 GMT https://community.qlik.com/t5/QlikView/Equivalent-to-Analytical-function-of-oracle-Syntax-at-script/m-p/104614#M603119 sergio0592 2018-10-15T11:02:11Z