Hello,
I have several support staff on my team and I'm trying to match their casework to our sales data to get an idea of the impact that they have on our overall sales. I've been able to muddle through a lot of problems in qlikview, but I'm not sure how to approach this.
From the Casework Table [Fact] I receive a list of up to 10 parts that were worked on a case. Each row contains the date the case was opened, the date the case was closed, the total case age, Case# , and the parts that were referenced in the case. There are up to 10 parts on a case and each one is loaded into qlikview in it's own column: Part1, Part2, Part3, etc.
In another table I have my Sales Data [Sales] with invoice date and part detail. Each row contains the Invoice date, part#, and Sales dollars.
I'd like match the parts from the Casework Table [Fact] to the Sales Data Table [Sales] if the part invoiced within two weeks of the case closing.
Will I need to match each part 1-10 to the sales data as separate expressions, or would I be better handling this another way? Thanks in advance for any guidance.
DJ
.. Check this link