Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Mark4
Partner
Partner

Concatenation of dates

I have an excel spreadsheet with 3 individual dates in three separate columns: Budget Date, Forecast Date, Execution Date.  

If one exists, the others are null.

I need to concatenate these three date fields in the load editor then run the [autoCalendar] script breaking them out into quarters, years, etc...

Running the script as-is I get three dates with the autocalendar, I need them to be combined into one so my pivot table will work properly.

Thank you for the help.

Labels (3)
1 Solution

Accepted Solutions
CELAMBARASAN
Partner
Partner

Create a new Date column by using Alt

Date(Alt([Budget Date], [Forecast Date], [Execution Date])) as CalendarDate

 

Thanks

Celambarasan

View solution in original post

1 Reply
CELAMBARASAN
Partner
Partner

Create a new Date column by using Alt

Date(Alt([Budget Date], [Forecast Date], [Execution Date])) as CalendarDate

 

Thanks

Celambarasan

View solution in original post