0 Replies Latest reply: May 22, 2012 3:05 AM by gmqlikview RSS

    Subtotals in Profit&Loss Statement



      I already manage to get the structure of my simple PL statement into QlikView sorting it with the LineNum.

      I now have got the problem to display Subtotals. I don't want to use the Pivottable because I don't like the design and it is going to be to broad after expanding.


      Please find attached my expamle I worked with. P02 (Operating income) should be the subtotal of P01 (Turnover). P05 (Operating profit) should be the total of all Ps.


      I did not manage to create a kind of sumif formula.


      For P05 it should sum up all values where in K1 is P05 because the level of P05 shows which K should be chosen for the sumif.


      Could you please help me with this? Or do you have a better idea to create a PL statement in QV?


      Many thanks!!!!