Counting ware

[#1]

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:

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

[MK_QSL]

Provide some 10-15 lines of data

[datanibbler]

Hi,

I can only see that there is a typo in your set_expression - the leaving_date cannot be before the entry_date, can it?