-
Re: Profit margin Help
Gysbert Wassenaar Jan 12, 2017 12:30 PM (in response to ohannis dikramanjian)That shouldn't be a big problem.
The ebay sales can be loaded into a Sales table. The transaction ID field is the logical choice for the key field that will link it to the Shipments table and the Payments table.
Load the shipments data in a Shipments table that's linked with the Sales and Payments table using the transaction ID key.
Load the paypal payments data in a Payments table that's linked with the Sales and Shipments table using the transaction ID key.
All the customer information can be consolidated in a Customers table. Keep only a Customer ID key in the Sales table to link it with the Customers table.
Finally the Products table with the data from your database which is linked to your Sales table using the SKU ID field.
Make sure the key fields that are used to link the tables have the exact same case sensitive name in the tables that should be linked.
-
Re: Profit margin Help
ohannis dikramanjian Jan 12, 2017 6:01 PM (in response to Gysbert Wassenaar )so far this is what i have done.
Step 1
add data
Ebay Sheet
Paypal Sheet
Shipping Sheet
Data Base Sheet
Step 2
create assassination between
Ebay sheet and PayPal sheet Transaction ID
Ebay Sheet and Paypal Sheet Transaction ID
Ebay Sheet and Shipping Sheet Transaction ID
Ebay Sheet and DataBase SKU
Step 3
Load Data
Please tell if so far all is good.
Next i need to find matching information and run the formula to calculate the sold price minus fees and charges from he cost. How can i achieve that section
-
Re: Profit margin Help
Gysbert Wassenaar Jan 13, 2017 12:35 PM (in response to ohannis dikramanjian)Please tell if so far all is good.
I'm afraid I have no idea if all is good. I can't see what you've done and what the data model in your Qlikview document now looks like. Perhaps you can create a small qlikview document with some example data. See this document: Preparing examples for Upload - Reduction and Data Scrambling
-
-
-
Re: Profit margin Help
ohannis dikramanjian Jan 13, 2017 1:56 PM (in response to ohannis dikramanjian)I am using quick sense t does not have save option. Do you want me to drop it in a dropbox and share it ?
by the way thanks for all your help.
-
Re: Profit margin Help
Rahul Pawar Jan 13, 2017 3:54 PM (in response to ohannis dikramanjian)Hello Ohannis,
Hope you are doing well!
Please use below sample script which will join & load data from different sources and calculate the required field. You can modify the script as per your need.
SampleSales: LOAD TransactionId, SoldPrice, eBayFees, CustomerInformation AS eBayCustomerInformation, SKU FROM SampleData.xlsx (ooxml, embedded labels, table is eBay); INNER JOIN LOAD TransactionId, CustomerInformation AS ShippingCustomerInformation, ShippingFees FROM SampleData.xlsx (ooxml, embedded labels, table is Shipping); INNER JOIN LOAD TransactionId, CustomerInformation AS PaypalCustomerInformation, PaypalFees FROM SampleData.xlsx (ooxml, embedded labels, table is Paypal); INNER JOIN LOAD ProductCost, SKU FROM SampleData.xlsx (ooxml, embedded labels, table is DBDump); Sales: LOAD TransactionId, SKU, SoldPrice, eBayFees, PaypalFees, ShippingFees, ProductCost, ProductCost - (SoldPrice - eBayFees - PaypalFees - ShippingFees) AS Profit Resident SampleSales; DROP Table SampleSales;
Hope this will help. !
Regards!
Rahul
-
ProfitMargin.qvw 160.2 K
-
SampleData.xlsx 9.4 K
-
-
Re: Profit margin Help
ohannis dikramanjian Jan 13, 2017 4:24 PM (in response to ohannis dikramanjian)I'm attaching the file, can you please modify so that i can make more sense I really appreciate your help.
-
Sales.qvf 3.0 MB
-