Week number in month

Thu, 22 May 2014 09:30:12 GMT

Hi ALL,

i have this calendar srcipt:

Load

Date as Date,

Month(Date) as Month,

Year(Date) as Year,

Week(Date) as Week,

WeekDay(Date) as WeekDay,

Day(Date) as Day,

'Q'&Ceil(Month(Date)/3) as Quarter,

'H'&Ceil(Month(Date)/6) as HalfYear,

MonthName(Date) as YearMonth,

Year(Date) &'-Q'& Ceil(Month(Date)/3) as YearQuarter,

Year(Date) &'-H'& Ceil(Month(Date)/6) as YearHalfYear

resident Temp;

And when i put week as dimension , i can see only week number. I want to see Year, mont name and week number of month(for example, when i select 2014 year and Mar month i see only week numbers(see atch), my expected result is 2014 Mar 1, 2014 Mar 2,2014 Mar 3,2014 Mar 4 . How can i modifie calendar scrip? Please help

Re: Week number in month

Thu, 22 May 2014 10:32:09 GMT

Use this,

Year(Date)&' '&Month(Date)&' '&Ceil(Day(Date)/7) as WeekNoofMonth

Thanks,

Prabhu

Re: Week number in month

Fri, 23 May 2014 05:48:57 GMT

Thanks!!!

topic Re: Week number in month in QlikView

Week number in month

Re: Week number in month

Re: Week number in month