Picking updated date field from data

[venkat1]

Hello all,

Please help me out from this logic,I am showing branch wise sales by taking Date-1 for calendar,Logic here i should apply here is If "Date-2" having  "-"  then i should take from Date-1 else i should consider a date from Date-2.
 
Branch    Date-1                    Date-2           Sales
A                14-06-2019             -                       1600
B                15-09-2015             -                       18000
C                12-04-2018        10-03-2017       3651
D                16-01-2015             -                       648
E                 02-05-2016       08-04-2017       5648

[Taoufiq_Zarra · Accepted solution]

if(len([Date-2])<2,[Date-1],[Date-2]) as New_Date2,

[Vegar · Accepted solution]

Is your empty - values actually the string "-"  or is it just Qlikview that is presenting NULL values as -.

If they are NULL values then you can use the Alt() function

Alt([Date-2],[Date-1]) as Date

If its not null, but a string, then use the if solution suggested by @Taoufiq_Zarra .