https://community.qlik.com/t5/Connectivity-Data-Prep/Data-Load-using-Google-Analytics-Query-Builder/m-p/1604777#M4209 <P>Hello,</P><P>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:</P><P>%26start-date%3d2019-05-31%26end-date%3d2019-07-18%</P><P>But I have two variables called vStartDate and vEndDate. How can I replace the hard coded dates with my variables?</P><P>Thanks!</P> Tue, 28 Dec 2021 20:28:27 GMT ricky_kersey 2021-12-28T20:28:27Z https://community.qlik.com/t5/Connectivity-Data-Prep/Data-Load-using-Google-Analytics-Query-Builder/m-p/1604777#M4209 <P>Hello,</P><P>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:</P><P>%26start-date%3d2019-05-31%26end-date%3d2019-07-18%</P><P>But I have two variables called vStartDate and vEndDate. How can I replace the hard coded dates with my variables?</P><P>Thanks!</P> Tue, 28 Dec 2021 20:28:27 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Data-Load-using-Google-Analytics-Query-Builder/m-p/1604777#M4209 ricky_kersey 2021-12-28T20:28:27Z https://community.qlik.com/t5/Connectivity-Data-Prep/Data-Load-using-Google-Analytics-Query-Builder/m-p/1604796#M4210 <P>Was much easier to do than I realized:</P><P>just simply replaced the date with $(vStartDate) so it looked like&nbsp; %26start-date%3d$(vStartDate)%</P> Mon, 22 Jul 2019 18:17:55 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Data-Load-using-Google-Analytics-Query-Builder/m-p/1604796#M4210 ricky_kersey 2019-07-22T18:17:55Z