topic Logic Help in QlikView

Logic Help

abhaysingh — Tue, 26 Jan 2016 13:15:00 GMT

Hi All,

How to convert Year, week to Date and month?

pls find the sample data

Anonymous — Tue, 26 Jan 2016 13:18:54 GMT

use function makeweekdate

makeweekdate(Year,Week)

swuehl — Tue, 26 Jan 2016 13:20:05 GMT

You can use MakeWeekDate() function:

MakeWeekDate(YYYY [ , WW [ , D ] ] )

Returns a date calculated from the year YYYY, the week WW and the day-of-week D.

If no day-of-week is stated, 0 (Monday) is assumed.

Examples:

makeweekdate(1999,6,6) returns 1999-02-14

makeweekdate(1999,6) returns 1999-02-08

Then apply Month() or MonthName() to the created date value.

...

MakeWeekDate( Year, Week) as Date,

MonthName( MakeWeekDate( Year, Week)) as MonthName,

...

abhaysingh — Tue, 26 Jan 2016 13:26:19 GMT

hi guys,

thanks, for revert, how i can fill missing dates??

swuehl — Tue, 26 Jan 2016 13:30:20 GMT

What do you mean with 'missing' in this context?

Are you talking about a master calendar?

Or more something like