Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Provide some 10-15 lines of data
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?