Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

erwinvullers
New Contributor

Coverting Week(+ Year) to a date (Start of week)

I'm new to Qlik Sense.

I have data from a Excel sheet which contains a Week field and a Year Field.

To make things easier for working with dates I try to convert the Week number to a Date field (For example the start date of that week)  within the Data manager, how can I do this in Qlik Sense?

5 Replies
OmarBenSalem
Esteemed Contributor

Re: Coverting Week(+ Year) to a date (Start of week)

Can you give me a sample data of your week field? Thanks

antoniotiman
Honored Contributor III

Re: Coverting Week(+ Year) to a date (Start of week)

Hi Erwin

use MakeWeekDate() Function

MakeWeekDate(YearField,WeekField)

Regards,

Antonio

erwinvullers
New Contributor

Re: Coverting Week(+ Year) to a date (Start of week)

I'm using QlikSense Desktop 3.2 SR4, but it does not recognize the "MakeWeekDate" command. am I missing something?

erwinvullers
New Contributor

Re: Coverting Week(+ Year) to a date (Start of week)

SOme Extra info I want to add this as an extra colomn within the Data Manager.

antoniotiman
Honored Contributor III

Re: Coverting Week(+ Year) to a date (Start of week)

Community Browser