topic Re: create date field using information in QlikView

create date field using information

bushpalaamarnat — Sat, 28 Jul 2018 13:05:30 GMT

Hi all,

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

Week

W30-18

Anil_Babu_Samineni — Sat, 28 Jul 2018 13:44:28 GMT

Not really sure your intend, Perhaps this?

Load DateField,

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

From Table;

bushpalaamarnat — Sun, 29 Jul 2018 14:14:44 GMT

getting error no date feild

sergio0592 — Sun, 29 Jul 2018 15:57:35 GMT

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')

pintucs20 — Thu, 02 Aug 2018 16:17:21 GMT

Its Correct

pintucs20 — Thu, 02 Aug 2018 16:22:33 GMT

Hi Great