topic Re: Loading multiple tabs Google spreadsheet in QlikView

Loading multiple tabs Google spreadsheet

Thu, 27 Mar 2014 10:37:05 GMT

Hi all,

I want to load in QlikView a google spreadsheet which contains differents tabs.

I can load the first tab using "Web file" wizard but I can't load the other tabs.

Do you have any ideas ?

Thanks,

Claire.

srchilukoori — Thu, 27 Mar 2014 13:53:09 GMT

Each tab has a different ID (#gid=*****) on the URL, you may have to use a web file load for each of these IDs

Thu, 27 Mar 2014 14:50:55 GMT

Yes, I noticed that but it does not work. Even if I change the end of the url (#gid=*****), it always load the first tab of my google spreadsheet.

Fri, 28 Mar 2014 13:47:07 GMT

The solution is to go into File>Publish to the web and enter in qlikview the url corresponding to the tab.