Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
LOAD SalesOrderID,
RevisionNumber,
OrderDate,
Status,
OnlineOrderFlag,
SalesOrderNumber,
PurchaseOrderNumber,
AccountNumber ,
CustomerID,
TerritoryID ,
BillToAddressID ,
ShipToAddressID ,
ShipMethodID,
TaxAmt,
Freight,
LocalCurrency
FROM
[QVD's\SalesOrderHeader.qvd]
(qvd);
Q1:- Sales transactions, whether online (Website) or direct (salesperson), have a sales
territory. As mentioned above salespeople are related to sales territories. In the
case of online sales the finished document should not show the salesperson
associated with the territory. Instead, the finished document must show the
transaction as a Website sale. As the QlikView developer, you must override the
salesperson for all online sales. Online sales are determined by a flag in the Sales
Order Header table.
LOAD F1,
[275],
[276],
[277],
[279],
[280],
[282],
[284],
[286],
[288],
[289],
[290],
Website
Q2:- The quota information is stored at a different level of detail than the actual sales transactions.
Sales quota is stored by Salesperson and Quarter. Sales transactions are stored
Daily. Online sales also has a quota stored in the same table. As the QlikView
developer, you must successfully resolve this ‘level of detail’ problem.
Freight and
can anyone make me understand that what I have to do in both questions?
Thnks in advance
Please don't clutter this site with duplicate discussions: