topic Re: How to create link between Sales and Quota in QlikView

How to create link between Sales and Quota

Sat, 26 Mar 2016 12:19:34 GMT

Can any one help me to create link between Quota and SalesOrderHeader Table and alos tell me how to convert quarter quota into monthly quota. In Quota excel, 275 to 290 are SalesPerson ID and date is Quartely.

and Desired Output is in desired output excel

Re: How to create link between Sales and Quota

Gysbert_Wassenaar — Sun, 27 Mar 2016 08:38:20 GMT

Please stop cluttering this site with duplicate discussions

how to show sales Vs Quota

How to show Sale Vs Quota

'Detail Level'

As I told you before in How to show Sale Vs Quota‌ there is no relation between the sales persons and the sales orders.

Re: How to create link between Sales and Quota

Sun, 27 Mar 2016 13:33:16 GMT

But the data is provided in the same this manner only. Then tell me how is possible that quota can not be linked with table. Sorry to say but i have to find the way to make it linked with table.

Re: How to create link between Sales and Quota

Gysbert_Wassenaar — Sun, 27 Mar 2016 14:28:43 GMT

The information does not exist in the source data. So there is no way. Unless your willing to present lies as results. In that case create a SalesPersonID field in the SalesOrderHeader table:

LOAD *, Ciel(Rand()*11)+274 as SalesPersonID FROM SalesOrderHeader.qvd (qvd);

And create a SalesPersonID field as well in the load statement that load the quotes data:

CrossTable(SalesPersonID,Quotes,2)

LOAD

F1 as QuarterStart,

Website,

[275],

[276],

[277],

[279],

[280],

[282],

[284],

[286],

[288],

[289],

[290]

FROM

[quota.xlsx] (ooxml, embedded labels, table is Sheet1)

;

That will link your tables. And all based on completely fabricated nonsense.