Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Tags (2)
2 Replies

Re: Counting ware

Provide some 10-15 lines of data

datanibbler
Esteemed Contributor

Re: Counting ware


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?

Community Browser