Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
malbordio
New Contributor III

RSS Date format in Qlikview

Hi,

I have imported the MS Office 365 rss feed into qlikview, but I have a problema with the date format.

Qlikview is not identifying it as a date format, just as normal text, so I cannot apply expressions that filter these dates such as just showing today's records, for example.

Feed:

http://rss.servicehealth.microsoftonline.com/feed/pt-PT/B7F70D7F85F11C8825780A4D1A857937/8p4qc7/gk1n...

Can someone tell me how can I do that please?

Attached the file. Thanks for the help!

1 Solution

Accepted Solutions
MVP
MVP

Re: RSS Date format in Qlikview

Load your tables as below...

item:

Load

     *,

     TimeStamp(TimeStamp#(Left(Trim(SubField(pubDate,',',-1)),20),'DD MMM YYYY hh:mm:ss')) as DateTimeField,

     Date(Floor(TimeStamp#(Left(Trim(SubField(pubDate,',',-1)),20),'DD MMM YYYY hh:mm:ss'))) as DateField,

     Time(Frac(TimeStamp#(Left(Trim(SubField(pubDate,',',-1)),20),'DD MMM YYYY hh:mm:ss'))) as TimeField;

LOAD link,

    title,

    description,

    pubDate,

    %Key_rss_48AB09FE9E3B67F7    // Key to parent table: rss

FROM [http://rss.servicehealth.microsoftonline.com/feed/pt-PT/B7F70D7F85F11C8825780A4D1A857937/8p4qc7/gk1n...] (XmlSimple, Table is [rss/channel/item])

;

View solution in original post

2 Replies
MVP
MVP

Re: RSS Date format in Qlikview

Load your tables as below...

item:

Load

     *,

     TimeStamp(TimeStamp#(Left(Trim(SubField(pubDate,',',-1)),20),'DD MMM YYYY hh:mm:ss')) as DateTimeField,

     Date(Floor(TimeStamp#(Left(Trim(SubField(pubDate,',',-1)),20),'DD MMM YYYY hh:mm:ss'))) as DateField,

     Time(Frac(TimeStamp#(Left(Trim(SubField(pubDate,',',-1)),20),'DD MMM YYYY hh:mm:ss'))) as TimeField;

LOAD link,

    title,

    description,

    pubDate,

    %Key_rss_48AB09FE9E3B67F7    // Key to parent table: rss

FROM [http://rss.servicehealth.microsoftonline.com/feed/pt-PT/B7F70D7F85F11C8825780A4D1A857937/8p4qc7/gk1n...] (XmlSimple, Table is [rss/channel/item])

;

View solution in original post

malbordio
New Contributor III

Re: RSS Date format in Qlikview

It works ! Many Thanks!