3 Replies Latest reply: Nov 23, 2011 11:11 AM by dip_anj1

Help With date Formatting

dip_anj1 Nov 22, 2011 4:10 PM

Hi I am very new to qlikview application so pardon my ignorance.I loaded data from csv files to qlikview application and kept the date format as M/DD/YYYY which is coming as Jan 1,2011 while I display in list box one of the date objects.Surprisingly I am unable to do any date operation on that field.Whenever I am trying to find week,month of that date field it is returning NULL.Am I missing something?My ultimate aim is to find last 4 weeks date based on a selection of that date field.Any help is highly appreciated

Re: Help With date Formatting

Miguel Angel Baeyens de Arce Nov 22, 2011 4:53 PM (in response to dip_anj1)
Hi,

Using the date format from the input CSVs will require some formatting in the LOAD:

Table: LOAD Date(Date#(DateField, 'MMM D, YYYY')) AS Date FROM File.csv;

Now you can add or subtract to dates, and calculate with them.

Hope that helps.

Miguel Angel Baeyens
BI Consultant
Comex Grupo Ibérica

File.csv 48 bytes

qcomLoadDatesFromCSV.qvw 145.0 K
Like Show 0 Likes (0)

Actions
- Re: Help With date Formatting
  
  dip_anj1 Nov 23, 2011 11:11 AM (in response to Miguel Angel Baeyens de Arce )
  
  Thanks Miguel that worked like a charm.But now I have one more problem.What I am trying to do is I have a date field in a list box coming from a clone of original calendar table.The calendar table date is used in the report.Now I want a mechanism so that when user selects a date from list box I need to restrict data in the report from selected date to 4 weeks period.I tried the same with calculated dimension without any luck.Please find the attached QVW file.It would be very helpful if you can suggest some steps to achieve that.I am using the personal edition so won't be able to download more than 3 personal edition files.
  
  Test.qvw 442.8 K
  
  Like Show 0 Likes (0)
  
  Actions
Re: Help With date Formatting

rohit gupta Nov 23, 2011 12:01 AM (in response to dip_anj1)

hi
table1:
LOAD
Date(Datefield,'MM/DD/YYYY) ad Date
or go to Properties>>>Number>>>checked date..and write your date format as per your requirment
thanks
rohit
Like Show 0 Likes (0)

Actions

Go to original post