topic Re: Dealer Analysis - Monthly in QlikView

Dealer Analysis - Monthly

suresh_rawat — Mon, 21 Jan 2013 09:23:50 GMT

Hi All,

I am making a report on Dealer Analysis month wise in which i have to present Retail Sales, Wholesale & Dealer Stock on month basis. In this report i am easily getting Retail Sales & wholesale, but i am stuck while taking dealer stock monthly from my system directly. Actually i am getting dealer stock from oracle database.

If someone make such report plz share an idea with me, or if someone is getting a dealer stock monthly plz share the query for that.

Thanks & Regards

Suresh Rawat

Re: Dealer Analysis - Monthly

Anonymous — Mon, 21 Jan 2013 09:40:45 GMT

It depends whether your system provides you with some sort of Item status record's stock level figure. If it does, it may only be available for the latest point in time.

To present the stock balances back through the preceeding months you may need to calculate the balance yourself from stock movements. A shortcut I've used before though is to take the item balance amount captured on sales and purchase orders that took the figures from the item status record's tock level figure.

Jonathan