Data Load using Google Analytics Query Builder

[ricky_kersey]

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!

[ricky_kersey · Accepted solution]

Was much easier to do than I realized:

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