topic Re: Expression for orders where completed date after order date in QlikView

Expression for orders where completed date after order date

rcorcoran — Tue, 26 Nov 2013 10:06:13 GMT

I am new to Qlikview and I am trying to write an expression for a chart that will count the Order ID
where the 'completed date' is 5 days after the 'order date'. The completed date and order date have timestamps also.

Thanks

Re: Expression for orders where completed date after order date

Tue, 26 Nov 2013 10:12:57 GMT

Can you post a sample app?

Re: Expression for orders where completed date after order date

rcorcoran — Tue, 26 Nov 2013 10:21:49 GMT

I really haven't a clue I was trying something like this:

count({$<[completed_date] = {$(=(order_date) + 5)}>} order_id)

But the date format for both the order date and completed_date is dd/mm/yy 00:00:00

Re: Expression for orders where completed date after order date

Nicole-Smith — Tue, 26 Nov 2013 14:52:29 GMT

Try this (if it doesn't work, please post a sample app):

count({$<[completed_date] = {$(=date((order_date) + 5, 'DD/MM/YY hh:mm:ss'))}>} order_id)

Re: Expression for orders where completed date after order date

Nicole-Smith — Tue, 26 Nov 2013 14:53:21 GMT

Also check that QV recognizes completed_date and order_date as dates/numbers (put each in a list box and make sure they are right aligned).