topic Re: P& L Account in QlikView

P& L Account

upaliwije — Sat, 21 Mar 2015 16:07:36 GMT

Hi Friends

I Have created a P&L account using Interval Match Concept explained in

See this blog post: How IntervalMatch Solved My Profit and Loss Dilemma

There you get following figures

Gross Sales 10000

Sales Returns -1000

Invoice Discount - 500

Sales Promoton -1000

Net Sales 7500

In my data table above minus figures are recorded as positive figures but the Net sales should be Rs.7500/- How can I do the modification to data model to solve this problem . Pls help

Re: P& L Account

trdandamudi — Sat, 21 Mar 2015 17:32:04 GMT

Is it possible to multiply Sales Return, Invoice Amount and Sales Promotion with -1 ? so that you get the desired result...

Re: P& L Account

Sat, 21 Mar 2015 18:51:23 GMT

Hi. We solved a similar problem for a p&l report by adding an extra field in the the p&l format table which indicated the sign for the specific row, i.e. 1 against all positive rows and -1 for all expense rows…something like:

P&L Header Sign

Net Sales 1

Sales Return -1

Invoice Discount -1

…..

Then in the chart expression just multiply with Sign field….

sum(…..Amount)*(Sign)