p &L

upaliwije — Fri, 11 Jul 2014 17:52:20 GMT

I have following data in an Excel sheet

Based on the above data I want to design the following output report in a QV document. Pls help me with a sample data model and report

Thanks in advance

Re: p &L

jerem1234 — Fri, 11 Jul 2014 18:22:00 GMT

Load the data into Qlikview, then use a straight table. The dimension would be Description and it will have 3 expressions:

sum(Actual)

sum(Budget)

sum(Budget)-sum(Actual)

Hope this helps!

upaliwije — Sat, 12 Jul 2014 11:26:30 GMT

Thanks

It is not working. I m unable to calculate the Gross Profit, Total Expenses and Profit

steve_crosby — Sat, 12 Jul 2014 11:45:38 GMT

Check out the following from the Resource Library

PrashantSangle — Sat, 12 Jul 2014 11:47:52 GMT

Hi,

Use Description as dimension

Write Expression for Gross Profit , Total Expenses and Proft.

1) Gross Profit

sum({<Description={'Sales'}>}Actual)-sum({<Description={'Purchase'}>}Actual)

2)Total Expenses:

sum({<Description={'Staff Exp'}>}Actual)-sum({<Description={'Other Exp'}>}Actual)

and 3)Profit

(sum({<Description={'Sales'}>}Actual)-sum({<Description={'Purchase'}>}Actual))

(sum({<Description={'Staff Exp'}>}Actual)-sum({<Description={'Other Exp'}>}Actual))

It is better for you if you calculated all fields at script level instead of trying in Chart

Regards