Account Summary Report

[sona_sa]

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.

[sona_sa]

Hello friends,

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

Thanks

[tresesco]

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.

[sona_sa]

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.