Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to extract days or months from the Twitter-timestamp?

Hi all,

I'm new with Qlikview and just started learning to use some regular expressions etc. I'm building my own social dashboard (with the QVsource connectors). All looks/goes well, ecxept for one thing:

When I load a search with the Twitter conector, I receive a colom called 'created_at' containing a timestamp with the following format:

Fri, 06 Apr 07:45:47 +0000

I tried to create a selection-table  with it by selecting the field and changing the format into date, but nothing happens. How can I extract a selection-table with only the days or months?

Can anyone help me out?

Regards,

Sebastian

1 Reply
Not applicable

Re: How to extract days or months from the Twitter-timestamp?

Found this elsewhere on the forum

=Timestamp(Date#(SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 2) & SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 3) & SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 6) & SubField('Fri Apr 01 00:40:57 +0000 2011', ' ', 4), 'MMMDDYYYYhh:mm:ss'))

Community Browser