Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Summing lines in a dimension to create a P&L

I have attached an example of some profit and loss data.

I want to add sales and cost of sales to give gross margin

then gross margin added to overheads to give profit before tax

then profit before tax to taxation to give profit after tax so that i get a profit and loss account as follows

Sales

Cost of Sales

Gross Margin

Overheads

Profit before Tax

Tax

Profit after tax

Any ideas?

Thank you

2 Replies
Not applicable
Author

Reload the data to get the costs as negative numbers

Not applicable
Author

I think I am nearly there with this new example but not quite. Any idea why the sums are not working for each type?