Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qv Source

I am using QV Source to pull data frm twitter and face book

but i am not able to set start and end date for which i need data

suppose for month july i want to set 1 jul to 31 jul.

and also facing problem in storing historical data.

is there some one who are using same connector to pull data into qlikview.

pls help me out how to write code for start n end date in qlikview so that i can pass date value using input box

and able to pull data for same date range.

4 Replies
Luminary Alumni
Luminary Alumni

Have you checked if there is limit for each trip? Something like GA had limit...

Have you tried to contact QV Source?




Not applicable

there is no option for start n end date for twitter conector

and face book connector only have since date option not end date.

i think , i have to stop loading all data by writing code so that what start date and end date i will

pass that date range data will be load in qlikview.

i want help in that how i can write this logic while loading table into qlikview.

Specialist II
Specialist II

Regarding the Twitter connector, which tables are you referring too? Unfortunately the Twitter Search API only lets you go back up to a maximum of a week or 1500 Tweets so if this is what you are trying to use I am not sure how useful a start/end date would be. If you can provide more detail it would help.

Regarding Facebook - I am assuming you mean the Facebook Fan Pages Connector? You are right there is no start/end date possibility yet on start date until present. However this is on our road map as the Facebook API would support this - please DM me if you would like early access to test this.

Regarding your issue storing historical data - could you explain this in more detail please? You can use the standard QlikView QVD method to store hostorical data and we have Facebook and Twitter demo applications which show this in detail but perhaps I am not understanding your quesion.

Specialist II
Specialist II

A minor update to my last point - the Twitter search API does allow you to supply an 'until' date so it only returns Tweets before that we are not currently exposing this in the Connector though and you would still be limited to a maximum of 1500 or a week's worth of Tweets and it doesn't seem that you can specify a since date.

So I am not sure how useful this would be - if you could DM me or explain more about what you are trying to achieve we will do our best to add this functionality in.