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: 
Not applicable

How to get before date

Hi experts,

I have a date like:12/12/2015,i want get the before dates like 11/12/2015,10/12/2015...... so on in data model not in front end.

Can any one help me on that......thanks in advance.....

8 Replies
sunny_talwar

Are you trying to get this in your master calendar? You will need to share more details before we might be able to help you here

its_anandrjs

You have to create a Master Calendar for missing dates.

See more here.

https://community.qlik.com/docs/DOC-9146

Regards

Anand

Not applicable
Author

HI Anand,

I want few date values like 3 or 5..not entire calendar.

thanks&regards

siva

Jacek
Educator-Ambassador
Educator-Ambassador

Maybe like this:

Load

Date,

Date(Date-1) as Date_1,

Date(Date-2) as Date_2,

Date(Date-3) as Date_3,

Product,

Value

Resident Table1;

previous_date.png

MarcoWedel

Hi,

one solution might be:

QlikCommunity_Thread_197911_Pic1.JPG

table1:

LOAD RecNo() as ID,

    Date(date-IterNo()+1) as date

INLINE [

    date

    12/12/2015

    31/10/2015

    25/08/2015

    17/05/2015

]

While IterNo()<=5;

hope this helps

regards

Marco

MarcoWedel

maybe also helpful:

QlikCommunity_Thread_197911_Pic2.JPG

table1:

LOAD RecNo() as ID,

    Date(date-IterNo()+1) as date,

    IterNo()-1 as AgeDays

INLINE [

    date

    12/12/2015

    31/10/2015

    25/08/2015

    17/05/2015

]

While IterNo()<=5;

regards

Marco

Not applicable
Author

Thanks Macro

MarcoWedel

You're welcome

please close your thread if your question is answered.

thanks

regards

Marco