How to get before date

[#1]

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

[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

[#4]

HI Anand,

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

thanks&regards

siva

[Jacek]

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;

[MarcoWedel]

Hi,

one solution might be:

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:

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

[#8]

Thanks Macro

[MarcoWedel]

You're welcome

please close your thread if your question is answered.

thanks

regards

Marco