topic Re: overwrite value of the expression in QlikView https://community.qlik.com/t5/QlikView/overwrite-value-of-the-expression/m-p/706858#M537268 <HTML><HEAD></HEAD><BODY><P>can you give an example?</P><P>You lost me at the point where a single row table has previous rows ?!?</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Tue, 28 Oct 2014 00:03:29 GMT MarcoWedel 2014-10-28T00:03:29Z overwrite value of the expression https://community.qlik.com/t5/QlikView/overwrite-value-of-the-expression/m-p/706857#M537267 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I have a table with one dimension and one row. I want to overwrite the value of expression in one row with the value of the previous.</P><P>How that can be done?</P></BODY></HTML> Mon, 27 Oct 2014 23:44:55 GMT https://community.qlik.com/t5/QlikView/overwrite-value-of-the-expression/m-p/706857#M537267 2014-10-27T23:44:55Z Re: overwrite value of the expression https://community.qlik.com/t5/QlikView/overwrite-value-of-the-expression/m-p/706858#M537268 <HTML><HEAD></HEAD><BODY><P>can you give an example?</P><P>You lost me at the point where a single row table has previous rows ?!?</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Tue, 28 Oct 2014 00:03:29 GMT https://community.qlik.com/t5/QlikView/overwrite-value-of-the-expression/m-p/706858#M537268 MarcoWedel 2014-10-28T00:03:29Z Re: Re: overwrite value of the expression https://community.qlik.com/t5/QlikView/overwrite-value-of-the-expression/m-p/706859#M537269 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have attached spreadsheet coming out from the table in Qlikview with the red number in one of the rows. This is where I want to have a negative value from the previous row. In the spreadsheet I added a line of code how I am trying to achieve it,</P><P></P><P>Regards,</P><P></P><P>Olivera</P></BODY></HTML> Tue, 28 Oct 2014 00:11:15 GMT https://community.qlik.com/t5/QlikView/overwrite-value-of-the-expression/m-p/706859#M537269 2014-10-28T00:11:15Z Re: overwrite value of the expression https://community.qlik.com/t5/QlikView/overwrite-value-of-the-expression/m-p/706860#M537270 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like this</P><P></P><P></P><P>If([Status Current] = '3. Total Active Unallocated', Above([Unallocated to Allocated]), "Actual Expression")</P><P></P><P>Note: In above expression replace "Actual Expression" with your expression.</P><P></P><P>Regards,</P><P>jagan.</P></BODY></HTML> Tue, 28 Oct 2014 03:09:07 GMT https://community.qlik.com/t5/QlikView/overwrite-value-of-the-expression/m-p/706860#M537270 jagan 2014-10-28T03:09:07Z Re: overwrite value of the expression https://community.qlik.com/t5/QlikView/overwrite-value-of-the-expression/m-p/706861#M537271 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>thank you all,</P><P></P><P>Above function worked here,</P><P></P><P>Regards,</P><P></P><P>Olivera</P></BODY></HTML> Wed, 29 Oct 2014 00:04:10 GMT https://community.qlik.com/t5/QlikView/overwrite-value-of-the-expression/m-p/706861#M537271 2014-10-29T00:04:10Z Re: overwrite value of the expression https://community.qlik.com/t5/QlikView/overwrite-value-of-the-expression/m-p/706862#M537272 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please close this thread if you got the answer by giving correct and helpful answers.</P><P></P><P>REgards,</P><P>Jagan.</P></BODY></HTML> Wed, 29 Oct 2014 01:49:11 GMT https://community.qlik.com/t5/QlikView/overwrite-value-of-the-expression/m-p/706862#M537272 jagan 2014-10-29T01:49:11Z