3 Replies Latest reply: Nov 11, 2015 3:51 PM by Bas van Reeuwijk RSS

    Challenging inventory (QlikSense) - Help please

    Helder de Oliveira

      For some reason I am not able to link an inventory cross table with the regular table (perhaps a loading issue).

       

      The first table (worksheet) shows the products and the expected inventory levels at that point in time.

      The second table (worksheet) shows products, quantity and date of arrival.

       

      I would like to compare my receipts and the inventory balance over time to make a very simple graph that can drill down the dates (month to weeks to days) - no problem if I need to make a separate link table just to link the dates with months and weeks.

       

      I tried it over the last few days and could not reach a solution.

       

      Please, help me. Attached is a sample of the data I am using.

       

      Thank you

      Helder

      +551598108300