Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I need to create one date per week. i.e., either tuesday or thursday till the current week.
Example.
.....................
06-10-2009
13-10-2009
20-10-2009
27-10-2009
3-11-2009.
and not more than 3-11-2009 if current date is 11-11-2009 then there should be 10-11-2009
Could you help me.
Regards,
R.Srinivasan.
Here's an untested example starting from a base date of Tuesday, January 1, 2008:
LOAD date(date#(20071225,'YYYYMMDD')+recno()*7) as Date
AUTOGENERATE floor((today()-date#(20071225,'YYYYMMDD'))/7);
Here's an untested example starting from a base date of Tuesday, January 1, 2008:
LOAD date(date#(20071225,'YYYYMMDD')+recno()*7) as Date
AUTOGENERATE floor((today()-date#(20071225,'YYYYMMDD'))/7);
Thank you JOHN, for your quick and exact reply.
Now i face some minor problem, how to handle this date with the report date.
I have some doubt in generating 80-20 chart dynamically. Could you help me.
Here is the link of the post. http://community.qlik.com/forums/p/22012/84152.aspx#84152