Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

bushpalaamarnat
Contributor

create date field using information

Hi all,

Kindly let me know, how create a date field using this information:

 

Week
W30-18
1 Solution

Accepted Solutions
sergio0592
Valued Contributor II

Re: create date field using information

Hi, try with this for fetch a date from your Week field :

=Date(Date#('01/01/'&right(Week,2),'DD/MM/YYYY')+mid(Week,2,2)*7,'DD/MM/YYYY')

View solution in original post

5 Replies

Re: create date field using information

Not really sure your intend, Perhaps this?

Load DateField,

         'W' & Week(DateField)&'-'&Num(Year(DateField),'00') as NewField

From Table;

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
bushpalaamarnat
Contributor

Re: create date field using information

getting error no date feild

sergio0592
Valued Contributor II

Re: create date field using information

Hi, try with this for fetch a date from your Week field :

=Date(Date#('01/01/'&right(Week,2),'DD/MM/YYYY')+mid(Week,2,2)*7,'DD/MM/YYYY')

View solution in original post

Highlighted
pintucs20
New Contributor III

Re: create date field using information

Its Correct

pintucs20
New Contributor III

Re: create date field using information

Hi Great