topic Re: 2 Dates in the same Table. in QlikView

2 Dates in the same Table.

ch_riadh — Mon, 20 Oct 2014 13:20:55 GMT

Please i need to show all the available stock .
for example if i choose March 2014.
i have to see all available stock.
available stock = car with received date < march 2014 and delivery date should be after march 2014, so it is still on stock.

Re: 2 Dates in the same Table.

upaliwije — Mon, 20 Oct 2014 13:26:50 GMT

Attach two calenders for received date and delivery date

Re: 2 Dates in the same Table.

Anonymous — Mon, 20 Oct 2014 13:46:39 GMT

Hi,

First Add only the "Variant" as the Dimension.

then in the expr add

COUNT({<Recieved_Date ={'< Date(01/03/2014)'},Delivery_Date ={'>= Date(01/03/2014)'}>}Stock_Number)