Discussion Board for collaboration on QlikView Scripting.
Hope someone can assist as I try to link sales based on two different variables (post code and division) to one sales person.
So if a sale is reported on postcode '1680' and 'shoes' the sales should be aligned to Paul. If the combination was '1680' and 'Clothing', then the sales should be aligned to Allan?
Any suggestions on how to write the script?
Thanks in advance.
Solved! Go to Solution.
Visually it should appear in QlikView like below (excel) example:
|Sum of Total Sales||Sales Rep|
I don't the crosstable will solve the issue since the sales file doesn't have the Sales Rep in it. I've attached the sales file so you can see what I mean. With an additional table I want to link the right Rep to the Postcode and Product. It's a good way for you to earn some 10 extra points
|Date||Customer||Post Code||Quantiy||Product||Unit Price||Total Sales|
Thanks for guiding me in the right direction Sokkorn. However, I need to find a workaround since:
Any suggestions to cover that?
Can you explain me more? I'm completely not get your requirment. There are a lot of method to do ETL in QlikView.
What kind of suggestion you need from us?
I've attached the .QVD in which you see the sales data which is available.
In the example you see that in postcode 1685 a sale is made in three categories:
The Excel file shows that each product is linked to a different sales person
The idea is that in the 'sales rep' listbox, you can select your sales person and see how he/she performed.
The structure for the tab 'Mapping' in Excel is done because changes apply on a regular basis. This would be the easiest way to maintain the spreadsheet.
Hope this clarifies my intentions.