topic Balance sheet formatting using macro in QlikView https://community.qlik.com/t5/QlikView/Balance-sheet-formatting-using-macro/m-p/519886#M194278 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am using multiple charts to display different items of <STRONG>Liabilities</STRONG> and <STRONG>Assets</STRONG>. E.g. "DEPOSIT FROM INDIVIDUAL" is one of the <STRONG>liability</STRONG> head and "CASH &amp; BANK BALANCES" is one of the <STRONG>asset</STRONG> head. I am using one chart to display all GLName and Amount for Name = "DEPOSIT FROM INDIVIDUAL" and another chart for Name = "CASH &amp; BANK BALANCES". I am using a macro in <STRONG>VBScript </STRONG>to achieve the output in text file. The required text format and the macro code I am using is attached below:</P><P></P><P>I want to display "DEPOSIT FROM INDIVIDUAL" to extreme left and "CASH &amp; BANK BALANCES" on right side. This format is attached.</P><P></P><P>Please let me know how can I achieve the desired output using macro.</P><P></P><P>Regards,</P><P>Mitesh </P></BODY></HTML> Tue, 03 Dec 2013 12:49:43 GMT 2013-12-03T12:49:43Z Balance sheet formatting using macro https://community.qlik.com/t5/QlikView/Balance-sheet-formatting-using-macro/m-p/519886#M194278 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am using multiple charts to display different items of <STRONG>Liabilities</STRONG> and <STRONG>Assets</STRONG>. E.g. "DEPOSIT FROM INDIVIDUAL" is one of the <STRONG>liability</STRONG> head and "CASH &amp; BANK BALANCES" is one of the <STRONG>asset</STRONG> head. I am using one chart to display all GLName and Amount for Name = "DEPOSIT FROM INDIVIDUAL" and another chart for Name = "CASH &amp; BANK BALANCES". I am using a macro in <STRONG>VBScript </STRONG>to achieve the output in text file. The required text format and the macro code I am using is attached below:</P><P></P><P>I want to display "DEPOSIT FROM INDIVIDUAL" to extreme left and "CASH &amp; BANK BALANCES" on right side. This format is attached.</P><P></P><P>Please let me know how can I achieve the desired output using macro.</P><P></P><P>Regards,</P><P>Mitesh </P></BODY></HTML> Tue, 03 Dec 2013 12:49:43 GMT https://community.qlik.com/t5/QlikView/Balance-sheet-formatting-using-macro/m-p/519886#M194278 2013-12-03T12:49:43Z Re: Balance sheet formatting using macro https://community.qlik.com/t5/QlikView/Balance-sheet-formatting-using-macro/m-p/519887#M194279 <HTML><HEAD></HEAD><BODY><P>Please guys, it would be really helpful if you could give me some insight on how to achieve the required functionality.</P><P>Request you to please help me on this.</P><P></P><P>Regards,</P><P>Mitesh</P></BODY></HTML> Fri, 06 Dec 2013 05:48:44 GMT https://community.qlik.com/t5/QlikView/Balance-sheet-formatting-using-macro/m-p/519887#M194279 2013-12-06T05:48:44Z