topic How to work with sales analysis? in QlikView

How to work with sales analysis?

Wed, 23 May 2012 03:06:06 GMT

I have tables below

Delivery (This serves as your sales)

Date DR# Item Qty Unit Price Total Amount

4/5/2012 1 A 2 10.00 20.00

4/6/2012 2 C 5 5.00 25.00

Sales Return (This will be LESS to the Delivery to get the total sales)

Date DR# Item Qty

4/10/2012 1 A 1

Here's my question, How much is my Sale on April 2012? April 5, 2012, April 6, 2012?

I got puzzled.

Wed, 23 May 2012 06:06:30 GMT

Hi,

You should always show it as on date.

So, your total sales should come as Delivery - Sales Return

Since, your return is on 10 April but you are not aware of it before 10 April. So, before 10 April you should show as

for Item A

Total sales = 20.00

on or After 10 April

for Iteam A

Total sales = 10.00

That way, you will always show the correct data which is as is available.

If needed you can also show it in 3 columns

Delivery | Sales Return | Effective Sales

Ashutosh

Wed, 23 May 2012 08:11:34 GMT

Thanks Ashutosh. Got your point!