How to use a variable in Google Analytics connector in Qlik Cloud
I'd like to use to the built-in Google Analytics connector in Qlik Cloud to fetch data from numerous Google Analytics accounts (views). I want to have a table of the IDs that I would loop through with the same query.
Code to get data from a single view is simple and it's something like this (the number in bold is the view id):
LIB CONNECT TO 'ga (qlikcloud_qlikid_user)';
LOAD metric_sessions as [DataFromQueryURI.metric_sessions];
I created a table with the list of IDs and tried to do a simple loop over the list and change the ID in bold with the value from the list but I failed. I tried different approaches but nothing worked. Does anyone know how to dynamically change in a loop a part of the With Properties statement?
Code or rather the approach that I tried but failed: