Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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


Cost of Sales

Gross Margin


Profit before Tax


Profit after tax

Any ideas?

Thank you

2 Replies
Not applicable

Reload the data to get the costs as negative numbers

Not applicable

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