Discussion Board for collaboration related to QlikView App Development.
I need to create one date per week. i.e., either tuesday or thursday till the current week.
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.
Go to Solution.
Here's an untested example starting from a base date of Tuesday, January 1, 2008:
LOAD date(date#(20071225,'YYYYMMDD')+recno()*7) as DateAUTOGENERATE floor((today()-date#(20071225,'YYYYMMDD'))/7);
View solution in original post
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