topic Re: Re: Account Summary Report in QlikView

Account Summary Report

sona_sa — Fri, 07 Nov 2014 05:41:54 GMT

Hello Team,

I have a requirement like:

I have a four field i.e : Parent Account Name, Account Name, Amount, Month. I need a report on the behalf of Parent Account name wise Account Name amount.

For reference I have send a jpeg file please check the attached document. Also I am sending a QVW file for development. Please make it for one Parent Name i.e :

GL GROUP

ADMINISTRATIVE & SELLING EXPENSES Month Jan Feb Mar Apr May Jun

LOSS DUE TO THEFT 9714 4767

PRIOR PERIOD EXPENSES 3582 7500 8393 6193

REGISTRAR & TRANSFER EXPENSES 4471 8606 4220 4746

SUNDRY BALANCE (W.OFF) 1

TOTAL ADMINISTRATIVE & SELLING EXPENSES 10000 15000 7500 14500 12532

ADVANCE TAX & TDS RECEIVABLE

TOTAL 120000 12345 78654 65489 96789

This a example. But Need in the same format.

Thanks.

Re: Account Summary Report

sona_sa — Fri, 07 Nov 2014 11:18:48 GMT

Hello friends,

For more ref. Please find the attached file. Notepad file is for output and QVW file is for Data.

Thanks

Re: Account Summary Report

tresB — Fri, 07 Nov 2014 11:26:39 GMT

Go though this link: How to Create a Profit and Loss Statement in QlikView, it takes a bit longer but you will probably learn a lot from it.

Re: Re: Account Summary Report

sona_sa — Fri, 07 Nov 2014 11:33:52 GMT

Thanks for reply. I am going through the same. By the mean while can u make a expression for the provided data.it is only for 2 glgroup.

For you it will not take more time.