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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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)