topic Re: doubt in before function in QlikView https://community.qlik.com/t5/QlikView/doubt-in-before-function/m-p/733784#M1063233 <HTML><HEAD></HEAD><BODY><P>Sorry !</P><P>Exp2 shoud be =Alt(Before(Exp2), 0) + Exp1</P></BODY></HTML> Wed, 01 Oct 2014 10:48:16 GMT CELAMBARASAN 2014-10-01T10:48:16Z doubt in before function https://community.qlik.com/t5/QlikView/doubt-in-before-function/m-p/733779#M1063228 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have an pivot table with data shown in image</P><P>but what i actually want is i want add another expression that sums before column ie</P><P>Q1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Q2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Q3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Q4</P><P>val1 val2&nbsp;&nbsp;&nbsp; val1 val2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; val1 val2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; val1&nbsp; val2</P><P>6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 21&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 26</P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 01 Oct 2014 09:55:51 GMT https://community.qlik.com/t5/QlikView/doubt-in-before-function/m-p/733779#M1063228 sibideepak 2014-10-01T09:55:51Z Re: doubt in before function https://community.qlik.com/t5/QlikView/doubt-in-before-function/m-p/733780#M1063229 <HTML><HEAD></HEAD><BODY><P>is anyone to reply !!!</P></BODY></HTML> Wed, 01 Oct 2014 10:23:20 GMT https://community.qlik.com/t5/QlikView/doubt-in-before-function/m-p/733780#M1063229 sibideepak 2014-10-01T10:23:20Z Re: Re: doubt in before function https://community.qlik.com/t5/QlikView/doubt-in-before-function/m-p/733781#M1063230 <HTML><HEAD></HEAD><BODY><P>PFA</P><P></P><P>I hope it will help you</P></BODY></HTML> Wed, 01 Oct 2014 10:31:01 GMT https://community.qlik.com/t5/QlikView/doubt-in-before-function/m-p/733781#M1063230 CELAMBARASAN 2014-10-01T10:31:01Z Re: doubt in before function https://community.qlik.com/t5/QlikView/doubt-in-before-function/m-p/733782#M1063231 <HTML><HEAD></HEAD><BODY><P>val1=Sum(AmtField)</P><P>val2=RangeSum(Before(Sum(AmtField),0,2))</P></BODY></HTML> Wed, 01 Oct 2014 10:32:46 GMT https://community.qlik.com/t5/QlikView/doubt-in-before-function/m-p/733782#M1063231 tresB 2014-10-01T10:32:46Z Re: doubt in before function https://community.qlik.com/t5/QlikView/doubt-in-before-function/m-p/733783#M1063232 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>In both peoples answer ..im not getting it..</P><P>here is my sample file</P></BODY></HTML> Wed, 01 Oct 2014 10:43:51 GMT https://community.qlik.com/t5/QlikView/doubt-in-before-function/m-p/733783#M1063232 sibideepak 2014-10-01T10:43:51Z Re: doubt in before function https://community.qlik.com/t5/QlikView/doubt-in-before-function/m-p/733784#M1063233 <HTML><HEAD></HEAD><BODY><P>Sorry !</P><P>Exp2 shoud be =Alt(Before(Exp2), 0) + Exp1</P></BODY></HTML> Wed, 01 Oct 2014 10:48:16 GMT https://community.qlik.com/t5/QlikView/doubt-in-before-function/m-p/733784#M1063233 CELAMBARASAN 2014-10-01T10:48:16Z Re: doubt in before function https://community.qlik.com/t5/QlikView/doubt-in-before-function/m-p/733785#M1063234 <HTML><HEAD></HEAD><BODY><P>Hi , </P><P>is this achievable from script or using variable because i dont want it in front end</P></BODY></HTML> Wed, 01 Oct 2014 11:02:30 GMT https://community.qlik.com/t5/QlikView/doubt-in-before-function/m-p/733785#M1063234 sibideepak 2014-10-01T11:02:30Z