Combining all the timeframes to per-hour basis (Social Media) <Qlikview + QVsource)

[#1]

Hi everyone,

I am working on a project using QVsource and Qlikview to visualise Social media data. Using the QV source connectors to Twitter and Facebook (and other social media platforms) I retrieve per minute, per second data. However I want to collate them together so I can analysis it on an hourly basis. Can someone please guide me on how I should do it? Thank you so much!

[marcus_sommer]

I assume there is somewhere an associated timestamp to these data which could be split in date and time and in timeframes like hour(timestamp), too.

- Marcus

[hic]

The easiest way is to load the hour instead of the entire timestamp, e.g. by using

     Timestamp(Floor( TimeStamp, 1/24 ), 'YYYY-MM-DD hh')

HIC