topic Re: Problem with Balance Sheet ? in QlikView https://community.qlik.com/t5/QlikView/Problem-with-Balance-Sheet/m-p/978944#M334376 <HTML><HEAD></HEAD><BODY><P>Thanks Neetha for the quick response , I got the solution.</P></BODY></HTML> Mon, 24 Aug 2015 12:08:04 GMT 2015-08-24T12:08:04Z Problem with Balance Sheet ? https://community.qlik.com/t5/QlikView/Problem-with-Balance-Sheet/m-p/978942#M334374 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I Hope your doing good!!!</P><P></P><P>I am newbie to Qlikview I started developing apps in Qlikview , I&nbsp; would like to develop a Qlikview Profit and loss statement for the finance department. </P><P></P><P></P><P>the data has the tables Account master, Fact, Profit and loss category for this data I&nbsp; would like to generate a balance sheet like the attachment.&nbsp; </P><P></P><P></P><P>Here Margin is difference between A2-A3 and these two are representing same group with different line numbers<BR />Supplies is group 2 total, and it has its own line number<BR />Payroll is the sum total of Group 3,&nbsp; the values in the group has their own line numbers</P><P>TotalOPP/Rates is the sum total of group 4&nbsp; excluding the Resort Opp</P><P>Netprofit is the Margin-(Supplies+Payroll+TotalOpp/Rates)</P><P></P><P>I have followed the steps those are stated in the <A href="https://community.qlik.com/docs/DOC-3324">How to Create a Profit and Loss Statement in QlikView</A> </P><P></P><P>I have taken Line number in the Interval Match , and I have prepared an excel with the fields Description and line number start and end</P><P>,calculation flag [I&nbsp; have taken C as is], Space flag [S as is] however I didn't get the chart.</P><P></P><P>could you please help me on this how can get this type of balance sheet.</P><P><A href="https://community.qlik.com/qlik-users/5914">jmc</A> <A href="https://community.qlik.com/qlik-users/15823">swuehl</A> <A href="https://community.qlik.com/qlik-users/146975">petter-s</A> <A href="https://community.qlik.com/qlik-users/23109">jagan</A> <A href="https://community.qlik.com/qlik-users/4003">hic</A> <A href="https://community.qlik.com/qlik-users/96544">gwassenaar</A>&nbsp; <A href="https://community.qlik.com/qlik-users/26418">tresesco</A>‌</P></BODY></HTML> Mon, 24 Aug 2015 06:15:02 GMT https://community.qlik.com/t5/QlikView/Problem-with-Balance-Sheet/m-p/978942#M334374 2015-08-24T06:15:02Z Re: Problem with Balance Sheet ? https://community.qlik.com/t5/QlikView/Problem-with-Balance-Sheet/m-p/978943#M334375 <HTML><HEAD></HEAD><BODY><P>Hi John,</P><P></P><P>Please post sample data so can help.</P><P></P><P>Regards</P><P>Neetha</P></BODY></HTML> Mon, 24 Aug 2015 10:43:00 GMT https://community.qlik.com/t5/QlikView/Problem-with-Balance-Sheet/m-p/978943#M334375 Anonymous 2015-08-24T10:43:00Z Re: Problem with Balance Sheet ? https://community.qlik.com/t5/QlikView/Problem-with-Balance-Sheet/m-p/978944#M334376 <HTML><HEAD></HEAD><BODY><P>Thanks Neetha for the quick response , I got the solution.</P></BODY></HTML> Mon, 24 Aug 2015 12:08:04 GMT https://community.qlik.com/t5/QlikView/Problem-with-Balance-Sheet/m-p/978944#M334376 2015-08-24T12:08:04Z Re: Problem with Balance Sheet ? https://community.qlik.com/t5/QlikView/Problem-with-Balance-Sheet/m-p/978945#M334377 <HTML><HEAD></HEAD><BODY><P>Great.</P><P></P><P>Regards</P><P>Neetha</P></BODY></HTML> Mon, 24 Aug 2015 12:48:09 GMT https://community.qlik.com/t5/QlikView/Problem-with-Balance-Sheet/m-p/978945#M334377 Anonymous 2015-08-24T12:48:09Z