Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to conver the normal date formate to isoweek?

Friends,
I have some fields in the .xlsx sheet for example, TicketNo, Status, TicketCreatedDate, and so on. Now the "TicketCreatedDate" is in the format of (4/15/2013  9:36:02 AM). So i nneed get all the date filed form the the sheet and i want to convert this date into its equivalent isoweek.

  1. Help me out to convert the date into isoweek format.
  2. How to create data source to load the data from .xlsx file?
  3. I am using the Microsoft Office Excel 2007 version. Do we need add any other driver to create the data source?
  4. How do we use the script to query the excl data?

Thanks,

1 Reply

Re: How to conver the normal date formate to isoweek?

1.  See the load script in the attached .qvw (File > Edit Script)

2.  We don't need to create a data source.  We can load directly from the .xlsx file (see the load script in the attached .qvw--File > Edit Script)

3.  No

4.  See the load script in the attached .qvw (File > Edit Script)

Community Browser