2 Replies Latest reply: Nov 6, 2014 5:50 AM by Friedrich Hofmann RSS

    Counting ware

      Hello everyone,

       

      I should display the historicized Amount of machines in our warehouse.

      We have a system with a barcode on every machine, informations like entry, reservation and leaving of the machine are saved in a Table which I load into Qlikview. 

       

      My idea was to have a Linechart that would Display the amount of machines in our warehouse daily.

      My expression looks similar to this:

       

      count({<entryDate= {"<=$(=max(kalendar.Date))"}, leavingDate= {"<=$(=entryDate)", ''}>} idBarcode)

       

      My Dimension is

       

      MonthName(entryDate)

       

      Now gives me back this:

      chart.PNG.png

       

      But I know that we had more than 84 machines in our warehouse in Septemper.

       

      What am I doing wrong?

       

      I tried everything I could think of...

       

      Thanks!

       

      Moritz