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




      Now gives me back this:



      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...