topic Comparison of two dates using set analysis in QlikView

Comparison of two dates using set analysis

Sat, 29 Nov 2014 08:04:23 GMT

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

Re: Comparison of two dates using set analysis

maxgro — Sat, 29 Nov 2014 08:32:28 GMT

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

Re: Comparison of two dates using set analysis

arulsettu — Sat, 29 Nov 2014 08:38:18 GMT

like this

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