Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Date

Hi Experts,

I have  two  date columns in excel data like  this ...

Date1                   Data2


10/mar/1999        10/mar/1999

16/june/2000  

25/oct/2001          27/oct/2001

05/feb/2002         15/feb/2002

06/Nov/1999


then  we ever the empty in Date2 then filled with date1 dates.


output like this:-



Date1                   Data2


10/mar/1999        10/mar/1999

16/june/2000         16/june/2000

25/oct/2001          27/oct/2001

05/feb/2002         15/feb/2002

06/Nov/1999         06/Nov/1999

1 Solution

Accepted Solutions
Highlighted
Employee
Employee

Re: Date

Use Alt() function

LOAD

date1

alt(date2,date1) as date2

from yourexcelfile.xls

View solution in original post

5 Replies
Highlighted
Employee
Employee

Re: Date

Use Alt() function

LOAD

date1

alt(date2,date1) as date2

from yourexcelfile.xls

View solution in original post

Highlighted

Re: Date

Hi,

You can also try,

Load Date1,

If(Len(Trim(Date2))=0, Date1, Date2) as Date2

From Excel;

Highlighted

Re: Date

Please close the thread by marking the correct answer if you got what you wanted.

Qlik Community Tip: Marking Replies as Correct or Helpful

Highlighted

Re: Date

Try like this

Load

Date1,

If(Len(Trim(Date2))=0, Date1, Date2) as Date2

From Table;

Highlighted
Specialist
Specialist

Re: Date

if(Date2, Date2, Date1)