topic Re: date formating prob in QlikView

date formating prob

rotero — Fri, 22 Jun 2012 00:40:14 GMT

hi,

i have a sql table that has a date fiel (complete date up to time)

and i load it using date(datefield) as Date1

it gives me value with format 'MM/DD/YYYY', this is fine with me because i just want to get the proper date without the time...

and i use table object because i want to display the per record details, BUT when i want to filter per Date1 i have this --see picture below first field is the default value frm SQL table and 2nd field is the result of date(datefield) as PAFDate

<---i got this when i look up for a date see the multiple line even if its the same date?ex. 02/10/2012

this image when i filter it by date i selected

can anyone help me understand pls....

Re: date formating prob

Fri, 22 Jun 2012 05:58:10 GMT

Its because of the timestamp factor. If you want to remove it please try date(floor(datefield))

Regards,

Kiran Rokkam.

Re: date formating prob

Fri, 22 Jun 2012 06:39:28 GMT

Hi,

You have multiple rows of data for a perticular date and if u want the total for that date remove the timestamp and you will get one row for that date.Try this in the script to remove timestamp:

=date(floor(Date),'DD-MM-YYYY')

Regards

Apurva

Re: date formating prob

rwunderlich — Fri, 22 Jun 2012 07:35:38 GMT

A great resource for understanding date and timestamp data is

http://community.qlik.com/docs/DOC-3102

-Rob

Re: date formating prob

rotero — Fri, 22 Jun 2012 08:12:09 GMT

tnx to all.. it did what i intend to do,,,

i think beginners should first understand how QV handles date value... and then how to format it