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: 
ch_riadh
Partner - Creator II
Partner - Creator II

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
Creator II
Creator II

Attach two calenders for received date and delivery date

Anonymous
Not applicable

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)