topic credit debit in QlikView https://community.qlik.com/t5/QlikView/credit-debit/m-p/374258#M493408 <HTML><HEAD></HEAD><BODY><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">hi,</P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">i have bank transaction table like this</P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">accno transactionid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; balance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; credit-amt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; debit-amt</P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">------------------------------------------------------------------------------------------------------</P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">100&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11/5/12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -</P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">100&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15/5/12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -</P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">100&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23/5/12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">100&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24/5/12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500</P><P></P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">this is the table .what i need the out table(it means qlikview staight table) is like this</P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">accno transactionid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; balance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; credit-amt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; debit-amt&nbsp;&nbsp;&nbsp;&nbsp; bal_amt</P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">--------------------------------------------------------------------------------------------------------</P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">100&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11/5/12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #0000ff;"><STRONG>5000</STRONG></SPAN></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">100&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15/5/12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG style="color: #0000ff;">5400</STRONG></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">100&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23/5/12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #0000ff;"><STRONG>5200</STRONG></SPAN></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">100&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24/5/12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #0000ff;"><STRONG>4700</STRONG></SPAN></P><P></P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;"><SPAN style="color: #0000ff;"><STRONG style="color: #ff0000;">please help me as soon as possible.........</STRONG></SPAN></P><P></P><P></P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;"><SPAN style="color: #0000ff;"><STRONG style="color: #ff0000;">Thanks</STRONG></SPAN></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;"><SPAN style="color: #0000ff;"><STRONG style="color: #ff0000;">vinodh c</STRONG></SPAN></P></BODY></HTML> Wed, 30 May 2012 06:04:46 GMT Qlik__Vinodh 2012-05-30T06:04:46Z credit debit https://community.qlik.com/t5/QlikView/credit-debit/m-p/374258#M493408 <HTML><HEAD></HEAD><BODY><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">hi,</P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">i have bank transaction table like this</P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">accno transactionid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; balance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; credit-amt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; debit-amt</P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">------------------------------------------------------------------------------------------------------</P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">100&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11/5/12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -</P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">100&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15/5/12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -</P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">100&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23/5/12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200</P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">100&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24/5/12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500</P><P></P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">this is the table .what i need the out table(it means qlikview staight table) is like this</P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">accno transactionid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; balance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; credit-amt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; debit-amt&nbsp;&nbsp;&nbsp;&nbsp; bal_amt</P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">--------------------------------------------------------------------------------------------------------</P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">100&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11/5/12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #0000ff;"><STRONG>5000</STRONG></SPAN></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">100&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15/5/12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG style="color: #0000ff;">5400</STRONG></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">100&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23/5/12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #0000ff;"><STRONG>5200</STRONG></SPAN></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">100&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24/5/12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #0000ff;"><STRONG>4700</STRONG></SPAN></P><P></P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;"><SPAN style="color: #0000ff;"><STRONG style="color: #ff0000;">please help me as soon as possible.........</STRONG></SPAN></P><P></P><P></P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;"><SPAN style="color: #0000ff;"><STRONG style="color: #ff0000;">Thanks</STRONG></SPAN></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;"><SPAN style="color: #0000ff;"><STRONG style="color: #ff0000;">vinodh c</STRONG></SPAN></P></BODY></HTML> Wed, 30 May 2012 06:04:46 GMT https://community.qlik.com/t5/QlikView/credit-debit/m-p/374258#M493408 Qlik__Vinodh 2012-05-30T06:04:46Z Re: credit debit https://community.qlik.com/t5/QlikView/credit-debit/m-p/374259#M493409 <HTML><HEAD></HEAD><BODY><P>See the attached qv file. Hope it helps.</P></BODY></HTML> Wed, 30 May 2012 06:15:16 GMT https://community.qlik.com/t5/QlikView/credit-debit/m-p/374259#M493409 Siva_Sankar 2012-05-30T06:15:16Z Re: credit debit https://community.qlik.com/t5/QlikView/credit-debit/m-p/374260#M493410 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>i need the sample application as i mention above ...</P></BODY></HTML> Wed, 30 May 2012 06:20:46 GMT https://community.qlik.com/t5/QlikView/credit-debit/m-p/374260#M493410 Qlik__Vinodh 2012-05-30T06:20:46Z Re: credit debit https://community.qlik.com/t5/QlikView/credit-debit/m-p/374261#M493411 <HTML><HEAD></HEAD><BODY><P>Hi Vinodh,</P><P></P><P>Let try this script:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>[Data]:</P><P>LOAD *,</P><P>&nbsp;&nbsp;&nbsp; RangeSum(balance + [credit] - [debit], Peek('bal_amt'))&nbsp;&nbsp;&nbsp; AS bal_amt;</P><P>LOAD * INLINE [</P><P>accno&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp; transactionid&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp; date&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp; balance&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp; credit&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp; debit</P><P>100&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp; 11-05-2012&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp; 5000&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,&nbsp;&nbsp;&nbsp; 0</P><P>100&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp; 15-05-2012&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,&nbsp;&nbsp;&nbsp; 400&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp; 0</P><P>100&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp; 23-05-2012&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,&nbsp;&nbsp;&nbsp; 200</P><P>100&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp; 24-05-2012&nbsp;&nbsp;&nbsp; ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,&nbsp;&nbsp;&nbsp; 500];</P></PRE><P>Or by expression:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>RangeSum(Above(SUM(balance) + SUM(credit) - SUM(debit), 0, RowNo()))</P></PRE><P></P><P>Hope this help.</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Wed, 30 May 2012 07:12:43 GMT https://community.qlik.com/t5/QlikView/credit-debit/m-p/374261#M493411 Sokkorn 2012-05-30T07:12:43Z Re: credit debit https://community.qlik.com/t5/QlikView/credit-debit/m-p/374262#M493412 <HTML><HEAD></HEAD><BODY><P>Thanks lot it is working</P><P><A _jive_internal="true" class="jiveTT-hover-user jive-username-link" href="https://community.qlik.com/people/sokkorn.cheav" id="jive-3327226799250261547296" style="color: #007fc0; font-weight: bold;">Sokkorn Cheav </A></P></BODY></HTML> Wed, 30 May 2012 09:00:28 GMT https://community.qlik.com/t5/QlikView/credit-debit/m-p/374262#M493412 Qlik__Vinodh 2012-05-30T09:00:28Z Re: credit debit https://community.qlik.com/t5/QlikView/credit-debit/m-p/374263#M493413 <HTML><HEAD></HEAD><BODY><P>Hi Vinodh,</P><P></P><P>Your are welcome. Another one please help to mark as correct answer. So that other guy can find it easy for a solution. On the other hand, if you mark it correct meant that this case is close.</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Wed, 30 May 2012 09:45:07 GMT https://community.qlik.com/t5/QlikView/credit-debit/m-p/374263#M493413 Sokkorn 2012-05-30T09:45:07Z Re: credit debit https://community.qlik.com/t5/QlikView/credit-debit/m-p/374264#M493414 <HTML><HEAD></HEAD><BODY><P>i&nbsp; have on dought on that ,it is u are making '0' insted of&nbsp; '-'</P><P>if it is '-' it will working or not ?</P></BODY></HTML> Wed, 30 May 2012 09:51:08 GMT https://community.qlik.com/t5/QlikView/credit-debit/m-p/374264#M493414 Qlik__Vinodh 2012-05-30T09:51:08Z Re: credit debit https://community.qlik.com/t5/QlikView/credit-debit/m-p/374265#M493415 <HTML><HEAD></HEAD><BODY><P>Hi Vinodh,</P><P></P><P>It is your data source store '-' instead of '0'? If like this, it will not work. So to get this working, we need to replace '-' to '0' value.</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Wed, 30 May 2012 09:54:52 GMT https://community.qlik.com/t5/QlikView/credit-debit/m-p/374265#M493415 Sokkorn 2012-05-30T09:54:52Z Re: credit debit https://community.qlik.com/t5/QlikView/credit-debit/m-p/374266#M493416 <HTML><HEAD></HEAD><BODY><P>ok,my data having '-' this how can i change this do u have any idea for that...</P></BODY></HTML> Wed, 30 May 2012 09:58:03 GMT https://community.qlik.com/t5/QlikView/credit-debit/m-p/374266#M493416 Qlik__Vinodh 2012-05-30T09:58:03Z Re: credit debit https://community.qlik.com/t5/QlikView/credit-debit/m-p/374267#M493417 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>[Data]:</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; IF(ISNULL(CR) OR LEN(CR)&lt;0,0,CR)&nbsp;&nbsp;&nbsp;&nbsp; AS [Credit],</P><P>&nbsp;&nbsp;&nbsp;&nbsp; .....</P><P>FROM .....</P><P></P><P>If can, share your sample data here. So that we can find a good solution together <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Wed, 30 May 2012 10:01:30 GMT https://community.qlik.com/t5/QlikView/credit-debit/m-p/374267#M493417 Sokkorn 2012-05-30T10:01:30Z Re: credit debit https://community.qlik.com/t5/QlikView/credit-debit/m-p/374268#M493418 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>this is my sample data....</P></BODY></HTML> Wed, 30 May 2012 10:06:53 GMT https://community.qlik.com/t5/QlikView/credit-debit/m-p/374268#M493418 Qlik__Vinodh 2012-05-30T10:06:53Z Re: credit debit https://community.qlik.com/t5/QlikView/credit-debit/m-p/374269#M493419 <HTML><HEAD></HEAD><BODY><P>Let try this</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P>[Data]:</P><P>LOAD *,</P><P>&nbsp;&nbsp;&nbsp; RangeSum(bal + [credit] - [debit], Peek('bal_amt'))&nbsp;&nbsp;&nbsp; AS bal_amt;</P><P>LOAD accountno, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; transno, </P><P>&nbsp;&nbsp;&nbsp; IF(ISNULL(debit) OR LEN(debit)&lt;0,0,debit)&nbsp;&nbsp;&nbsp; AS debit, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; //credit, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; IF(ISNULL(credit) OR LEN(credit)&lt;0,0,credit)&nbsp;&nbsp;&nbsp; AS credit, </P><P>&nbsp;&nbsp;&nbsp; // bal,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; IF(ISNULL(bal) OR LEN(bal)&lt;0,0,bal)&nbsp;&nbsp;&nbsp; AS bal</P><P>FROM Book1.xlsx</P><P>(ooxml, embedded labels, table is Sheet1);</P></PRE><P></P><P>See sample attached file.</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Wed, 30 May 2012 10:15:33 GMT https://community.qlik.com/t5/QlikView/credit-debit/m-p/374269#M493419 Sokkorn 2012-05-30T10:15:33Z Re: credit debit https://community.qlik.com/t5/QlikView/credit-debit/m-p/374270#M493420 <HTML><HEAD></HEAD><BODY><P>thanks lot <SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #ffffff;">Sokkorn,it is working ..</SPAN></P></BODY></HTML> Wed, 30 May 2012 10:24:12 GMT https://community.qlik.com/t5/QlikView/credit-debit/m-p/374270#M493420 Qlik__Vinodh 2012-05-30T10:24:12Z Re: credit debit https://community.qlik.com/t5/QlikView/credit-debit/m-p/374271#M493421 <HTML><HEAD></HEAD><BODY><P>Hi Vinodh,</P><P></P><P>Your are the most welcome friend.</P><P></P><P>Cheer!!</P><P><BR />Sokkorn</P></BODY></HTML> Wed, 30 May 2012 10:25:43 GMT https://community.qlik.com/t5/QlikView/credit-debit/m-p/374271#M493421 Sokkorn 2012-05-30T10:25:43Z Re: credit debit https://community.qlik.com/t5/QlikView/credit-debit/m-p/374272#M493422 <HTML><HEAD></HEAD><BODY><P>hi <SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #ffffff;">Sokkorn</SPAN></P><P>it is working for only one account-no,i need to work different account-no also ......</P></BODY></HTML> Wed, 30 May 2012 10:34:51 GMT https://community.qlik.com/t5/QlikView/credit-debit/m-p/374272#M493422 Qlik__Vinodh 2012-05-30T10:34:51Z Re: credit debit https://community.qlik.com/t5/QlikView/credit-debit/m-p/374273#M493423 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Let check in the attached file.</P><P></P><P>Do let me know, if you need further assistant.</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Wed, 30 May 2012 11:21:28 GMT https://community.qlik.com/t5/QlikView/credit-debit/m-p/374273#M493423 Sokkorn 2012-05-30T11:21:28Z credit debit https://community.qlik.com/t5/QlikView/credit-debit/m-p/374274#M493424 <HTML><HEAD></HEAD><BODY><P>thank you </P></BODY></HTML> Wed, 30 May 2012 11:38:42 GMT https://community.qlik.com/t5/QlikView/credit-debit/m-p/374274#M493424 Qlik__Vinodh 2012-05-30T11:38:42Z credit debit https://community.qlik.com/t5/QlikView/credit-debit/m-p/374275#M493427 <HTML><HEAD></HEAD><BODY><P>It is working for you?</P></BODY></HTML> Wed, 30 May 2012 11:41:15 GMT https://community.qlik.com/t5/QlikView/credit-debit/m-p/374275#M493427 Sokkorn 2012-05-30T11:41:15Z credit debit https://community.qlik.com/t5/QlikView/credit-debit/m-p/374276#M493428 <HTML><HEAD></HEAD><BODY><P>yes.it is working super..............</P></BODY></HTML> Wed, 30 May 2012 11:42:12 GMT https://community.qlik.com/t5/QlikView/credit-debit/m-p/374276#M493428 Qlik__Vinodh 2012-05-30T11:42:12Z credit debit https://community.qlik.com/t5/QlikView/credit-debit/m-p/374277#M493429 <HTML><HEAD></HEAD><BODY><P>Good friend. Just let you know that do not try with load script. We should use expression for a better one.</P></BODY></HTML> Wed, 30 May 2012 11:46:26 GMT https://community.qlik.com/t5/QlikView/credit-debit/m-p/374277#M493429 Sokkorn 2012-05-30T11:46:26Z