Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
praveenavelagap
Contributor III

Twitter metrics in QVsource

Can I find individual tweet favorites, retweets,replies using QVSource?

Tags (2)
1 Solution

Accepted Solutions
chrisbrain
Valued Contributor

Re: Twitter metrics in QVsource

Do you mean you would like to input a Tweet ID and get the count of the favorites, retweets and replies?

If so, the TweetLookup table will give you the favourite and Retweet count. e.g. for this:

https://twitter.com/MSNBC/status/654148404738703360

You also get these columns in other tables which return Tweets (e.g. the Search tables).

I do not think you will get the reply count like this, to do this you would have to gather all the Tweets you were interested in (e.g. using the Search table) and then use some script to check the in_reply_to_status_id field for all Tweets and count them up.

3 Replies
chrisbrain
Valued Contributor

Re: Twitter metrics in QVsource

Do you mean you would like to input a Tweet ID and get the count of the favorites, retweets and replies?

If so, the TweetLookup table will give you the favourite and Retweet count. e.g. for this:

https://twitter.com/MSNBC/status/654148404738703360

You also get these columns in other tables which return Tweets (e.g. the Search tables).

I do not think you will get the reply count like this, to do this you would have to gather all the Tweets you were interested in (e.g. using the Search table) and then use some script to check the in_reply_to_status_id field for all Tweets and count them up.

praveenavelagap
Contributor III

Re: Twitter metrics in QVsource

Thanks Chris.I have one more Question, Since twitter data is about 15 pages /1 week data; can we have storage internally? Did anyone did this?? i feel like it is not only insert, insert update?Please guide me pn this

chrisbrain
Valued Contributor

Re: Twitter metrics in QVsource

‌Yes, you can store and accumulate your data into QVD files which is a standard Qlik file format.