Discussion board where members can get started with QlikView.
I have two date columns in excel data like this ...
then we ever the empty in Date2 then filled with date1 dates.
output like this:-
Use Alt() function
alt(date2,date1) as date2
View solution in original post
You can also try,
If(Len(Trim(Date2))=0, Date1, Date2) as Date2
Please close the thread by marking the correct answer if you got what you wanted.
Qlik Community Tip: Marking Replies as Correct or Helpful
Try like this
if(Date2, Date2, Date1)