Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.....
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
You have to create a Master Calendar for missing dates.
See more here.
https://community.qlik.com/docs/DOC-9146
Regards
Anand
HI Anand,
I want few date values like 3 or 5..not entire calendar.
thanks®ards
siva
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;
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
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
Thanks Macro
You're welcome
please close your thread if your question is answered.
thanks
regards
Marco