topic Re: Date Expression in QlikView

Date Expression

Anonymous — Thu, 08 Mar 2018 10:26:48 GMT

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.

prma7799 — Thu, 08 Mar 2018 10:28:44 GMT

Please share some sample with Expected Output

Anonymous — Thu, 08 Mar 2018 10:36:09 GMT

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 — Thu, 08 Mar 2018 10:40:00 GMT

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 — Thu, 08 Mar 2018 10:52:54 GMT

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 — Thu, 08 Mar 2018 11:08:01 GMT

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 — Thu, 08 Mar 2018 11:08:49 GMT

Start_date and End_date , this two tables are already loaded.