topic Re: help in QlikView

help

NavinReddy — Thu, 25 Jul 2013 11:45:08 GMT

Hi community,

i have date

1.how can i get previous five weeks ,

2.this month total weeks,

3.starting year to till date months should disply

all three different expressions

some one help me

thanks in advance

rohith

Thu, 25 Jul 2013 12:00:46 GMT

1.how can i get previous five weeks ,==Date(WeekStart(Today())-35)

2.this month total weeks,===Floor(day(MonthEnd(today()))/7)

3.starting year to till date months should disply===if(Datefield>=YearStart(today()) and Datefield<=YearStart(today()), Datefield )

NavinReddy — Thu, 25 Jul 2013 12:06:29 GMT

hi kabilan,

thank you for your reply,

i will try this examples

Thanks,

rohith

Thu, 25 Jul 2013 12:11:23 GMT

rolling 5 week

sum({<Date={">=$(=Date(weekstart(today())-35)<=$(=date(weekend(today())-35))"}, year=,month=,week=>}sales)