Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Below is what I have so far
This is what I am trying to achieve
Total is a calculation of a sum of stock and outstanding stock and Weeks of cover is total/avg weekly usage
Unfortunately I do not have the ability to reload the data and do any joins
Any help would be gratefully received
Dave
Please post a small qlikview document that demonstrates the problem.
how do I do that?
I've been told I can't upload the sample because of security implications.
If I explain my issue another way you might be able to help
I have a straight using one set analysis called INVHST and another straight table using the set analysis PUR.
I want to link the tables via material and width so I can see any outstanding purchase orders any against the width and material.
Can tables with different set analysis be linked or is this something that needs to be coded in when the data is loaded in?
Perhaps this helps: Preparing examples for Upload - Reduction and Data Scrambling