'Detail Level'

Fri, 25 Mar 2016 16:00:02 GMT

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

Re: Sale as website and quota 'Detail Level'

Gysbert_Wassenaar — Fri, 25 Mar 2016 16:22:06 GMT

Please don't clutter this site with duplicate discussions:

How to show Sale Vs Quota

how to show sales Vs Quota

topic 'Detail Level' in QlikView

'Detail Level'

Re: Sale as website and quota 'Detail Level'