Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Need to Create a date per week i.e., either Tuesday or Thursday till the current week

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.

1 Solution

Accepted Solutions
MVP
MVP

Need to Create a date per week i.e., either Tuesday or Thursday till the current week

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);

View solution in original post

2 Replies
MVP
MVP

Need to Create a date per week i.e., either Tuesday or Thursday till the current week

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);

View solution in original post

Not applicable

Need to Create a date per week i.e., either Tuesday or Thursday till the current week

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