topic Re: week number formuale issue in QlikView

week number formuale issue

Karim_Khan — Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

whats wrong with the below code.

'WEEK'& Week(If([WEEKNAME] = Right([WEEKNAME],2), '10', '4' OR '5', [WEEKNAME]),[WEEKNAME]) as [EXPECTED WEEK FORMAT]

Regards,

stalwar1‌celambarasan‌tushi0407‌israrkhan‌jagannalla‌New to QlikView‌

Re: week number formuale issue

sunny_talwar — Thu, 13 Oct 2016 13:13:08 GMT

What are you trying to do. Something is not right about this syntax? May be if you explain, we might be able to help you out here

Re: week number formuale issue

Karim_Khan — Thu, 13 Oct 2016 14:37:40 GMT

I want to show the entire years week number which starts from 1 to 53 should show in WEEK1,WEEK2,WEEK3,WEEK4,WEEK5 depending upon the month selection.

Re: week number formuale issue

rupamjyotidas — Thu, 13 Oct 2016 15:07:45 GMT

Doesn't this help?

'Week'&week(TempDate) As Week,

Re: week number formuale issue

Karim_Khan — Thu, 13 Oct 2016 15:15:54 GMT

I want all those week number in customize frmat i.e each week of evry month should fall into WEEK1,WEEK2,WEEK3,WEEK4,WEEK5 category

Re: week number formuale issue

MarcoWedel — Thu, 13 Oct 2016 21:13:58 GMT

Hi,

maybe helpful:

How to get the number of week per month?

AutoNumber(Week(Date),MonthName(Date)) as MonthWeek

regards

Marco

Re: week number formuale issue

MarcoWedel — Thu, 13 Oct 2016 22:00:07 GMT

not quite what you specified, but maybe helps nevertheless:

CALENDAR:
LOAD MONTH(DATE) as MONTH,
    WEEK(DATE) AS WEEK,
    Date(MonthStart(DATE),'MMM-YYYY') as CALENDAR_MONTH_ID,
    DATE AS DAY_DT,   
    WeekNAME(DATE,0,-1) AS WEEKNAME,
    WeekDay(DATE) AS WEEK_DAY,
    If(WeekDay(DATE) <> 'Sat' AND  WeekDay(DATE) <> 'Sun',DATE) AS WEEKEND,
    Year(DATE) as YEAR
    ;
LOAD Date(MakeDate(2014)+IterNo()-1) as DATE
AutoGenerate 1
While MakeDate(2014)+IterNo()-1<=Today();

LEFT JOIN
LOAD WEEKNAME,
    Date(Min(CALENDAR_MONTH_ID),'MMM-YYYY') as MinMonth,
    'Week'&AutoNumber(WEEKNAME,Max(CALENDAR_MONTH_ID)) as ALTERNATEWEEKFORMAT
Resident CALENDAR
Group By WEEKNAME
Order By WEEKNAME

regards

Marco