Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Date Expression

I have two date dimension--->Start_date and End_date.

Now, i want to create another date dimension which is greater than Start_date and less than End_date.

In that case , how can i write this date expression.

Please tell me exact expression for that.

6 Replies
prma7799
Master III
Master III

Please share some sample with Expected Output

Anonymous
Not applicable
Author

if  i select this anonymous  date -' 06/17/2017'

then my output will be coming this type--->>>

start _date                 End_date

05/17 /2017             05/17/2018

i want this type of output.

Anonymous
Not applicable
Author

if  i select this anonymous  date -' 06/17/2017'

then my output will be coming this type--->>>

Project_start _date                 Project_End_date

05/17 /2017                           05/17/2018

i want this type of output which fectch the data from this anonymous date.

prma7799
Master III
Master III

Like this?

Test:

LOAD * Inline [

Dates

17-06-2017

18-06-2017

19-06-2017

];

New:

LOAD Dates ,

Previous(Dates) as  StartDate ,

AddYears((Previous(Dates)),1) as EndDate

Resident Test;

Anonymous
Not applicable
Author

But, i have huge amount of dates.I have already loaded the data as Start_date and End_date.

iN THAT CASE, I need proper expression for that.

Anonymous
Not applicable
Author

Start_date and End_date , this two tables are already loaded.