Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

2 Replies
MK_QSL
MVP
MVP

Provide some 10-15 lines of data

datanibbler
Champion
Champion


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?