Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
PrashantRupani
Creator
Creator

Subtract 2 dates in set analysis Qlik Sense

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

Labels (1)
1 Solution

Accepted Solutions
agigliotti
Partner
Partner

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

View solution in original post

2 Replies
agigliotti
Partner
Partner

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

View solution in original post

PrashantRupani
Creator
Creator
Author

Thanks for the quick reply. This worked.