we have a problem which my collegues and i are struggling to solve - we got this project for the univercity as a graduation project, we should develop a data structure and apps in qlik sense for a company in supply chain management. we managed a little structure, where to collect the data from customers and how to calculate, but unfortunately have no experience in qlik sense or in supply chain management. so we have been searching for answers for a while now and i thought i would try my chances here. any help is immensely appreciated.
the topic is the following:
With the help of "QlikSense" an interactive overview and a related detail view of the following subareas of the end-to-end supply chain shall be created:
here are some simplified tables i have. we need to be able to calculate and visualize otif (delivered on time in full) and forecast accuracy - as difference between customer order and our predicted value. if anyone could help that would be incredible.