Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Highlighted
ricky_kersey
New Contributor II

Data Load using Google Analytics Query Builder

Hello,

I am creating an app in Qlik Sense using Google Analytics data. I have used the GA Query Builder to build my data load query. The issue is, which I know has been pointed out in the past but I can't find a direct answer, my query URL has hard coded dates:

%26start-date%3d2019-05-31%26end-date%3d2019-07-18%

But I have two variables called vStartDate and vEndDate. How can I replace the hard coded dates with my variables?

Thanks!

1 Solution

Accepted Solutions
ricky_kersey
New Contributor II

Re: Data Load using Google Analytics Query Builder

Was much easier to do than I realized:

just simply replaced the date with $(vStartDate) so it looked like  %26start-date%3d$(vStartDate)%

1 Reply
ricky_kersey
New Contributor II

Re: Data Load using Google Analytics Query Builder

Was much easier to do than I realized:

just simply replaced the date with $(vStartDate) so it looked like  %26start-date%3d$(vStartDate)%