Subtract 2 dates in set analysis Qlik Sense

[PrashantRupani]

I am trying to subtract 2 dates in Qlik Sense using set analysis

My requirement is show Order No's where Order Delivery Date - Order Ship date >=7

     --So A-B>=7 , I am trying to write A>=B+7 in set analysis

Expression :

sum( {<Order Delivery Date={">=$(=Order Ship Date+7)"} >} Order Delivery Date - Order Ship date)

The expression is not working. Can you please let me know what needs to be changed? I'd greatly appreciate your support.

Thanks

Prashant

[agigliotti · Accepted solution]

Hi @PrashantRupani ,

Maybe this:

=sum( {< [Order number] ={"=([Order Delivery Date] - [Order Ship date])>=7"} >} [Order Delivery Date] - [Order Ship date] )

I hope it can helps.

Best Regards

[PrashantRupani]

Thanks for the quick reply. This worked.