Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create link between Sales and Quota

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

3 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
Not applicable
Author

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.

Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand