Is there anyone who can help me with the development of Google Analytics in QlikView by using QVSource?
The question is: I am loading all the articles which are published on our website into QlikView from 2009. You can imagine this is a big load.
Is it possible to load the data from 2009 until today once (it will not change anymore) and with every reload, load the new data into it, without reloading from 2009? And after that the same for the next day, and so on.
Hey Thanks - Sounds like a great solution, I had never really tried using the SQL INSERT, UPDATE commands from QlikView script! Can you insert entire tables worth of data in single commands or do you need to do some sort of row level loop?
Thanks!
Chris
beeido.com - BI | Software | Qlik Integration Services GitFirst - A CI/CD solution for Qlik Sense
Hi Henco - I'd be happy to have a screen share with you to see if I can help you develop/debug the script, you can always post the solution back here for the benefit of others. It might even be useful as a sample on the QVSource wiki.
beeido.com - BI | Software | Qlik Integration Services GitFirst - A CI/CD solution for Qlik Sense
Could you please explain to me in which way I can load data for a whole year into QV by using the sleep function? Do I need to make 365 scripts, one for each date (I don't think so)? I am not familiair with the loop function in QV, so I'm not sure on how to use it. I hope you can help me some further.
Unfortunately there is no key like visitor_id or anything. My solution was to create a concatenated key to get as close to an individual visitor as possible. I combined date, hour, latitude and longitude to create a key. The problem is that you can only query 7 dimensions at once, so that only left me with 3 more dimensions. So I just created separate queries each with the 4-field key and 3 separate dimensions. They all became associated in QlikView based on the 4-field key.
