Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

ch_riadh
Not applicable

2 Dates in the same Table.

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.

2 Replies
upaliwije
Not applicable

Re: 2 Dates in the same Table.

Attach two calenders for received date and delivery date

karthigayan
Not applicable

Re: 2 Dates in the same Table.

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)