Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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])

;

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])

;

malbordio
New Contributor III

Re: RSS Date format in Qlikview

It works ! Many Thanks!