Problem with Balance Sheet ?

[#1]

Hi All

I Hope your doing good!!!

I am newbie to Qlikview I started developing apps in Qlikview , I  would like to develop a Qlikview Profit and loss statement for the finance department.

the data has the tables Account master, Fact, Profit and loss category for this data I  would like to generate a balance sheet like the attachment. 

Here Margin is difference between A2-A3 and these two are representing same group with different line numbers
Supplies is group 2 total, and it has its own line number
Payroll is the sum total of Group 3,  the values in the group has their own line numbers

TotalOPP/Rates is the sum total of group 4  excluding the Resort Opp

Netprofit is the Margin-(Supplies+Payroll+TotalOpp/Rates)

I have followed the steps those are stated in the How to Create a Profit and Loss Statement in QlikView

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

,calculation flag [I  have taken C as is], Space flag [S as is] however I didn't get the chart.

could you please help me on this how can get this type of balance sheet.

jmc swuehl petter-s jagan hic gwassenaar  tresesco‌

[Anonymous]

Hi John,

Please post sample data so can help.

Regards

Neetha

[#3]

Thanks Neetha for the quick response , I got the solution.

[Anonymous]

Great.

Regards

Neetha