hello,
I have created a dashboard in Qlikview 11. I am looking for a way to connect the data stored in smartsheet to this dashboard automatically.
anyone knows how to do it?
I couldn't find any info
I need this for a CFO meeting
Thanks!!!!
Letizia
I am not familiar with Qlikview specifically but you should look at using the Smartsheet Live Data Connector along with the ODBC support in Qlikview. The data shown in Qlikview (or any other data visualization tool that can connect to an ODBC source) will always be live. Note the Live Data Connector is only available to Enterprise customers.
Here is a link I found with information about connecting an ODBC source to Qlikview
http://www.qlik.com/us/explore/solutions/data-source/qlikview-data-sources
Here is a link explaining the Smartsheet Live Data Connector: http://help.smartsheet.com/customer/portal/articles/1910037
I am also working a project where I need to integrate Smartsheets into Qlik. I followed the below site for assistance.
http://smartsheet-platform.github.io/odbc-docs/#download
I have successfully been able to Load in 1 project into Qlikview, however, I am currently struggling to bring in multiple projects. If you are still working this project, perhaps we can discuss further.