Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
abhijit79008
Contributor
Contributor

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

abhijit79008
Contributor
Contributor
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.

abhijit79008
Contributor
Contributor
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;

abhijit79008
Contributor
Contributor
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.

abhijit79008
Contributor
Contributor
Author

Start_date and End_date , this two tables are already loaded.