Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Comparison of two dates using set analysis

Hi

I have a requirement wherein I would want to get the orders which got delayed by 10 days on shipment.So to get the same I have written a expression like this

count({<shipmentdate={>=$(=date((orderdate+5),'DD/MM/YYYY')}>}orderid)a

But it is not giving me the desired results.So can anyone please help me on the same

2 Replies
maxgro
MVP
MVP

=count({$<orderid={"=(shipmentdate>=(orderdate+10))"}>} orderid)

arulsettu
Master III
Master III

like this

=count({<shipmentdate={">=$(=date((orderdate+5),'DD/MM/YYYY')<=$(=date((orderdate+10),'DD/MM/YYYY')"}>}orderid)