topic Re: replicate set analysis in script in QlikView https://community.qlik.com/t5/QlikView/replicate-set-analysis-in-script/m-p/858753#M1016641 <HTML><HEAD></HEAD><BODY><P>Maybe this:</P><P></P><P>LOAD</P><P>...</P><P>num(sum(if(Flag&lt;&gt;'Value1', Importe*Cambio)) + sum(ImporteAV), '.###,0') as NewField</P><P>...</P><P>LOAD (or RESIDENT or FROM) ...</P><P>GROUP BY ...</P></BODY></HTML> Fri, 17 Apr 2015 16:09:10 GMT Anonymous 2015-04-17T16:09:10Z replicate set analysis in script https://community.qlik.com/t5/QlikView/replicate-set-analysis-in-script/m-p/858752#M1016640 <HTML><HEAD></HEAD><BODY><P>Hi i've created this expresion in a graph</P><P></P><P>Num(sum({$&lt;Flag=Flag - {Value1}&gt;} Importe*Cambio) + sum(ImporteAV),'.###,0')</P><P></P><P>I need to replicate this in the script</P><P></P><P>I tried a few things but they didn't work</P><P></P><P>What should i do? </P><P></P><P>Thank you!</P></BODY></HTML> Fri, 17 Apr 2015 15:57:26 GMT https://community.qlik.com/t5/QlikView/replicate-set-analysis-in-script/m-p/858752#M1016640 2015-04-17T15:57:26Z Re: replicate set analysis in script https://community.qlik.com/t5/QlikView/replicate-set-analysis-in-script/m-p/858753#M1016641 <HTML><HEAD></HEAD><BODY><P>Maybe this:</P><P></P><P>LOAD</P><P>...</P><P>num(sum(if(Flag&lt;&gt;'Value1', Importe*Cambio)) + sum(ImporteAV), '.###,0') as NewField</P><P>...</P><P>LOAD (or RESIDENT or FROM) ...</P><P>GROUP BY ...</P></BODY></HTML> Fri, 17 Apr 2015 16:09:10 GMT https://community.qlik.com/t5/QlikView/replicate-set-analysis-in-script/m-p/858753#M1016641 Anonymous 2015-04-17T16:09:10Z