topic Re: How to get before date in QlikView

How to get before date

Tue, 29 Dec 2015 12:44:46 GMT

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

Re: How to get before date

sunny_talwar — Tue, 29 Dec 2015 14:39:14 GMT

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

Re: How to get before date

its_anandrjs — Tue, 29 Dec 2015 14:49:20 GMT

You have to create a Master Calendar for missing dates.

See more here.

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

Regards

Anand

Re: How to get before date

Tue, 29 Dec 2015 16:17:55 GMT

HI Anand,

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

thanks&regards

siva

Re: How to get before date

Jacek — Tue, 29 Dec 2015 20:22:32 GMT

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;

Re: How to get before date

MarcoWedel — Wed, 30 Dec 2015 01:23:57 GMT

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

Re: How to get before date

MarcoWedel — Wed, 30 Dec 2015 01:28:31 GMT

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

Re: How to get before date

Wed, 30 Dec 2015 08:33:46 GMT

Thanks Macro

Re: How to get before date

MarcoWedel — Wed, 30 Dec 2015 09:39:39 GMT

You're welcome

please close your thread if your question is answered.

thanks

regards

Marco