topic Re: Opening Balance Calculation in QlikView

topic Re: Opening Balance Calculation in QlikView https://community.qlik.com/t5/QlikView/Opening-Balance-Calculation/m-p/1198189#M883738 <HTML><HEAD></HEAD><BODY><P>Check this out</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139479_Capture.PNG" style="height: 55px; width: 620px;" /></P></BODY></HTML> Mon, 03 Oct 2016 17:42:07 GMT sunny_talwar 2016-10-03T17:42:07Z Opening Balance Calculation https://community.qlik.com/t5/QlikView/Opening-Balance-Calculation/m-p/1198188#M883737 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Hi Guys,</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Greetings...!!!</SPAN></P><P></P><P>I have below data for which I want to calculate my Closing & Opening balance.</P><P>   </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 337px;"><TBODY><TR><TD class="xl64" height="20" width="91">Vertical</TD><TD class="xl64" style="border-left: none;" width="138">Year_Month</TD><TD class="xl64" style="border-left: none;" width="108">Amount Paid</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">RBG</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">201603</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">100.5</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;"></TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">201604</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">120.3</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;"></TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">201605</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">135.5</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;"></TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">201606</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">145.8</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;"></TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">201607</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">168.4</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;"></TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">201608</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">180.5</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">CBG</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">201603</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">45.2</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;"></TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">201604</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">58.6</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;"></TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">201605</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">65.9</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;"></TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">201606</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">75.2</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;"></TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">201607</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">88.8</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;"></TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">201608</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">98.1</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">RABG</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">201603</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">24.5</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;"></TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">201604</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30.5</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;"></TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">201605</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">42.6</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;"></TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">201606</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">48.8</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;"></TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">201607</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">54.7</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;"></TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">201608</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">60.8</TD></TR></TBODY></TABLE><P></P><P>Below output is expected. Also Vertical & Year_Month are my dimension.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="1102"><TBODY><TR><TD class="xl69" height="20" width="112">Vertical</TD><TD class="xl70" colspan="5" style="border-left: none;" width="330">RBG</TD><TD class="xl70" colspan="5" style="border-left: none;" width="330">CBG</TD><TD class="xl70" colspan="5" style="border-right: 1.0pt solid black; border-left: none;" width="330">RABG</TD></TR><TR><TD class="xl72" height="20" style="border-top: none;">Year_Month</TD><TD align="right" class="xl75" style="border-top: none; border-left: none;">201604</TD><TD align="right" class="xl75" style="border-top: none; border-left: none;">201605</TD><TD align="right" class="xl75" style="border-top: none; border-left: none;">201606</TD><TD align="right" class="xl75" style="border-top: none; border-left: none;">201607</TD><TD align="right" class="xl75" style="border-top: none; border-left: none;">201608</TD><TD align="right" class="xl75" style="border-top: none; border-left: none;">201604</TD><TD align="right" class="xl75" style="border-top: none; border-left: none;">201605</TD><TD align="right" class="xl75" style="border-top: none; border-left: none;">201606</TD><TD align="right" class="xl75" style="border-top: none; border-left: none;">201607</TD><TD align="right" class="xl75" style="border-top: none; border-left: none;">201608</TD><TD align="right" class="xl75" style="border-top: none; border-left: none;">201604</TD><TD align="right" class="xl75" style="border-top: none; border-left: none;">201605</TD><TD align="right" class="xl75" style="border-top: none; border-left: none;">201606</TD><TD align="right" class="xl75" style="border-top: none; border-left: none;">201607</TD><TD align="right" class="xl76" style="border-top: none; border-left: none;">201608</TD></TR><TR><TD class="xl73" height="20" style="border-top: none;">Closing Balance</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">120.3</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">135.5</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">145.8</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">168.4</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">180.5</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">58.6</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">65.9</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">75.2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">88.8</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">98.1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">30.5</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">42.6</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">48.8</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">54.7</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">60.8</TD></TR><TR><TD class="xl74" height="21" style="border-top: none;">Opening Balance</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">100.5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">120.3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">135.5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">145.8</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">168.4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">45.2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">58.6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">65.9</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">75.2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">88.8</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">24.5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">30.5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">42.6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">48.8</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">54.7</TD></TR></TBODY></TABLE><P></P><P><A href="https://community.qlik.com/qlik-users/4003" target="_blank">hic</A>‌ <A href="https://community.qlik.com/qlik-users/74292" target="_blank">jaganmohanrao</A>‌</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Opening-Balance-Calculation/m-p/1198188#M883737 sumeet-vaidya 2020-11-25T16:16:04Z Re: Opening Balance Calculation https://community.qlik.com/t5/QlikView/Opening-Balance-Calculation/m-p/1198189#M883738 <HTML><HEAD></HEAD><BODY><P>Check this out</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139479_Capture.PNG" style="height: 55px; width: 620px;" /></P></BODY></HTML> Mon, 03 Oct 2016 17:42:07 GMT https://community.qlik.com/t5/QlikView/Opening-Balance-Calculation/m-p/1198189#M883738 sunny_talwar 2016-10-03T17:42:07Z