Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..........
Hi all.....
pls Can anyone reply me...........
thanks in advance
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.
Hi Dhananjay,
Have u did the qlikview developer certification....
Pls reply me ....
Hi
could you pls reply me...
I have some doubts in the certification....
thanks in advance
Yes,
I am a QliTech certified QV Developer as well as Trainer. Tell me what information you need from me regarding this subject.
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 2nd month in Q1 will compare the 2nd month in the preceding quarters.*
I m not understand the above point
Could you help me..
thanks in advance
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.
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
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