topic Minimum dates from two dates field in QlikView

Minimum dates from two dates field

rkpatelqlikview — Tue, 15 Oct 2019 07:29:55 GMT

Dear Team,

Please help me on this scenario. There is a condition, I want to consider the Minimum date from two dates and if Date1 is null ,need to consider Date2 vise versa. After generated new date field i need to count days by using Today()-Newdate. Thanks in advance.

Re: Minimum dates from two dates field

jyothish8807 — Tue, 15 Oct 2019 08:18:37 GMT

Hi ,

Try like this:

If( Sent_Date >= Final_date and len(Sent_Date )>0 and len(Final_date )>0, Sent_Date ,

if( Sent_Date < Final_date and len(Sent_Date )>0 and len(Final_date )>0, Final_Date,

if(len(Sent_Date )=0 and len(Final_date )>0,Sent_Date ,Final_date )))

For interval: Date(today(),'DD/MM/YYYY')- Above exp

Br,

Re: Minimum dates from two dates field

rkpatelqlikview — Tue, 15 Oct 2019 09:50:27 GMT

Thank you so much KC.

Re: Minimum dates from two dates field

jyothish8807 — Tue, 15 Oct 2019 10:03:05 GMT

You are welcome 🙂