How to get compare two day and choose the last? - Qlik Community

tka_ovako · ‎2017-12-08

Hello.

I need to compare two days and filter the latest date.

OrderNro	Day1	Day2
109555	16.10.2017	16.10.2017
109555	16.10.2017	9.10.2017
109555	16.10.2017	2.10.2017
109555	16.10.2017	25.9.2017
109555	16.10.2017	18.9.2017
109555	16.10.2017	11.9.2017

I need to filter those days thereby that if Day1 is equal to Day 2 only Day 1 value will be shown. Is there Aby load statement to do that on any expression?

BR.

Timo

PrashantSangle · ‎2017-12-08

use if statement in load statement

Like

Load *, if(date1=date2,date1,date2) as new_date

from table;

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂