topic Re: Counting ware in QlikView https://community.qlik.com/t5/QlikView/Counting-ware/m-p/777822#M473413 <HTML><HEAD></HEAD><BODY><P>Provide some 10-15 lines of data</P></BODY></HTML> Thu, 06 Nov 2014 10:48:18 GMT MK_QSL 2014-11-06T10:48:18Z Counting ware https://community.qlik.com/t5/QlikView/Counting-ware/m-p/777821#M473412 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I should display the historicized Amount of machines in our warehouse. </P><P>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.&nbsp; </P><P></P><P>My idea was to have a Linechart that would Display the amount of machines in our warehouse daily.</P><P>My expression looks similar to this:</P><P></P><P>count({&lt;entryDate= {"&lt;=$(=max(kalendar.Date))"}, leavingDate= {"&lt;=$(=entryDate)", ''}&gt;} idBarcode)</P><P></P><P>My Dimension is</P><P></P><P>MonthName(entryDate)</P><P></P><P>Now gives me back this:</P><P><IMG alt="chart.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/70621_chart.PNG.png" style="width: 620px; height: 244px;" /></P><P></P><P>But I know that we had more than 84 machines in our warehouse in Septemper.</P><P></P><P>What am I doing wrong?</P><P></P><P>I tried everything I could think of...</P><P></P><P>Thanks!</P><P></P><P>Moritz</P></BODY></HTML> Thu, 06 Nov 2014 10:40:29 GMT https://community.qlik.com/t5/QlikView/Counting-ware/m-p/777821#M473412 2014-11-06T10:40:29Z Re: Counting ware https://community.qlik.com/t5/QlikView/Counting-ware/m-p/777822#M473413 <HTML><HEAD></HEAD><BODY><P>Provide some 10-15 lines of data</P></BODY></HTML> Thu, 06 Nov 2014 10:48:18 GMT https://community.qlik.com/t5/QlikView/Counting-ware/m-p/777822#M473413 MK_QSL 2014-11-06T10:48:18Z Re: Counting ware https://community.qlik.com/t5/QlikView/Counting-ware/m-p/777823#M473414 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I can only see that there is a typo in your set_expression - the leaving_date cannot be before the entry_date, can it?</P></BODY></HTML> Thu, 06 Nov 2014 10:50:01 GMT https://community.qlik.com/t5/QlikView/Counting-ware/m-p/777823#M473414 datanibbler 2014-11-06T10:50:01Z