Using variables in a QVSource GA Feed URL

Wed, 27 Nov 2013 00:01:16 GMT

I'm trying to loop through a load script from QVSource Google Analytics connector.

The script looks like the following:

GoogleAnalyticsConnectorV3_DataFromQueryURI:

LOAD

dim_dateHour as DataFromQueryURI_dim_dateHour,

dim_eventLabel as DataFromQueryURI_dim_eventLabel,

dim_eventAction as DataFromQueryURI_dim_eventAction,

metric_totalEvents as DataFromQueryURI_metric_totalEvents

FROM

[http://localhost:5555/QVSource/GoogleAnalyticsConnectorV3/?table=DataFromQueryURI&appID=&feed=https%3a%2f%2fwww.googleapis.com%2fanalytics%2fv3%2fdata%2fga%3fids%3dga%253AXXXXXXXX%26dimensions%3dga%253AdateHour%252Cga%253AeventLabel%252Cga%253AeventAction%26metrics%3dga%253AtotalEvents%26filters%3dga%253AeventCategory%253D%7estart%2524%26start-date%3d2011-01-01%26end-date%3d2013-11-26%26max-results%3d5000]

(qvx);

I'd like to loop through the bolded part of the connection string; it's an 8 digit number.

How can I put a variable into the connection string?

Re: Using variables in a QVSource GA Feed URL

Nicole-Smith — Wed, 27 Nov 2013 14:25:52 GMT

Here is an example of how I connect to my database using variables:

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=$(vDBName);Data Source=$(vDBServer);Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=$(vWorkstation);Use Encryption for Data=False;Tag with column collation when possible=False];

Note that vDBName, vDBServer, and vWorkstation are all variables that I had populated earlier in my load script.

topic Using variables in a QVSource GA Feed URL in QlikView

Using variables in a QVSource GA Feed URL

Re: Using variables in a QVSource GA Feed URL