This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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.
Create a new Date column by using Alt
Date(Alt([Budget Date], [Forecast Date], [Execution Date])) as CalendarDate
View solution in original post