find the sum of sales for the employees based on dates

[#1]

Hi all

I have the two tables one is salesorder table and another one is territory table

in salesorder table i have the fields territoryid,sales and orderdate

in territory table i have the fields salesman,territoryId,startdate,enddate

startdate is the salesman joining date,enddate is salesman leaving date,

i take the year as year(orderdate) and month(orderdate) as month

if i select any one salesman, i want to see the sum(sales) for the selected year,but if he not work that here it should show as null or empty

here i want to compare the startdate and enddate of the salesman regarding the orderdate..

how to do it...

can anyone help me pls..........

[#2]

Hi all.....

pls Can anyone reply me...........

thanks in advance

[#3]

Hi, You can do this with using Intervalmatch function. Please follow the below script: SalesOrder:

SalesOrder:

LOAD SalesOrderID,

SalesOrderID AS SalesOrderCount,

RevisionNumber AS [Revision Number],

Date(OrderDate) AS [Order Date],

CustomerID,

TerritoryID,

BillToAddressID,

ShipToAddressID;

SQL SELECT *

FROM SalesOrderHeader

ORDER BY OrderDate;

SalesTerritory:

LOAD BusinessEntityID AS EmployeeBusinessEntityID,

TerritoryID,

Date(StartDate) AS StartDate,

Date(If(IsNull(EndDate), Today(), EndDate)) AS EndDate;

SQL SELECT *

FROM SalesTerritoryHistory;

JOIN IntervalMatch([Order Date])

LOAD StartDate, EndDate

Resident SalesTerritory;

Please revert back for any futerh query in this regard.

[#4]

Hi Dhananjay,

Have u did the qlikview developer certification....

Pls reply me ....

[#5]

Hi

could you pls reply me...

I have some doubts in the certification....

thanks in advance

[#6]

Yes,

I am a QliTech certified QV Developer as well as Trainer. Tell me what information you need from me regarding this subject.

[#7]

Hi

I dont know how to do the sales vs Quota

in quota table they give the details as like employee Id's and website,how to import that table,i tried using cross table,

website field also come under empolyee Id's...

also how to show the website sales in the list box as a salesman..

that is,in verification data they give the direct sales details as salesmanwise,

but website sales as total online sales not depends on the salesman,

whether shall i show the website as the one of the field in salesman list, that is list of salesman plus website in the listbox

if yes how to show that one..

one more req is

· Quarter over quarter Sales on a rolling 3 quarter period and within a period regardless of a calendar selection i.e. selecting the 2^nd month in Q1 will compare the 2^nd month in the preceding quarters.*

I m not understand the above point

Could you help me..

thanks in advance

[#8]

HI,

As sepecified in specs document you need to convert all online sales to Website Sales. So there in Salesperson list box it it should show one more sales person called Website Sales. Regarding Quarter over Quarter sales I also couldn't do that.

Sorry in this regard I can't help you as it's certification and you should do it at your own which will really boost up your confidence.

[#9]

Hi

How to convert online sales into website sales

i have only the online flag and the salesperson only do the direct and online sales

how to do this..

could you help me

[#10]

Hi

Could you pls help how to show sales Vs Quota

in quota table i have salesmanId and website

how to link the sales table into quota table..

using salesmantId we will link the tables but here one field as website..

how to solve the level of detail problem