topic Accessing Qlikview data from external process in QlikView https://community.qlik.com/t5/QlikView/Accessing-Qlikview-data-from-external-process/m-p/203736#M1207324 <HTML><HEAD></HEAD><BODY><P>So using the QlikView API, I can't access the data directly like I can with a SQL statement? I can only export data? When I export the data using the API would I have to tap into existing controls that have been built for that Qlikview application or can I query the data directly from that application? Hope that makes since. I am just trying to decide where most of our data transfermations would reside. I don't want all our final "cleaned" data stored in only Qlikview if I won't be able to all the things I would if that "cleaned" data was on the database server.</P></BODY></HTML> Fri, 06 Nov 2009 04:12:24 GMT 2009-11-06T04:12:24Z Accessing Qlikview data from external process https://community.qlik.com/t5/QlikView/Accessing-Qlikview-data-from-external-process/m-p/203734#M1207322 <HTML><HEAD></HEAD><BODY>If I chose to use Qlikview as my transformed data repository, would I be able to use the Qlikview application to return query information for external processes? Can I use Qlikview like a data server that has a mini data warehouse? Or is it smart to have a clean datahouse seperate from what is loaded into Qlikview, so that windows application and other report methods can use it. Then use the Qlikview data for Qlikview related development.</BODY></HTML> Wed, 04 Nov 2009 21:31:39 GMT https://community.qlik.com/t5/QlikView/Accessing-Qlikview-data-from-external-process/m-p/203734#M1207322 2009-11-04T21:31:39Z Accessing Qlikview data from external process https://community.qlik.com/t5/QlikView/Accessing-Qlikview-data-from-external-process/m-p/203735#M1207323 <HTML><HEAD></HEAD><BODY><P>There are operations (e.g. Store in script) &amp; functions in charts to drop data into external file formats (e.g. CSV and XLS). It will depend on your external reporting needs (vs. use of QlikView) to determine how appropriate these are to your requirements.</P></BODY></HTML> Fri, 06 Nov 2009 03:54:02 GMT https://community.qlik.com/t5/QlikView/Accessing-Qlikview-data-from-external-process/m-p/203735#M1207323 Qlik_Trigg 2009-11-06T03:54:02Z Accessing Qlikview data from external process https://community.qlik.com/t5/QlikView/Accessing-Qlikview-data-from-external-process/m-p/203736#M1207324 <HTML><HEAD></HEAD><BODY><P>So using the QlikView API, I can't access the data directly like I can with a SQL statement? I can only export data? When I export the data using the API would I have to tap into existing controls that have been built for that Qlikview application or can I query the data directly from that application? Hope that makes since. I am just trying to decide where most of our data transfermations would reside. I don't want all our final "cleaned" data stored in only Qlikview if I won't be able to all the things I would if that "cleaned" data was on the database server.</P></BODY></HTML> Fri, 06 Nov 2009 04:12:24 GMT https://community.qlik.com/t5/QlikView/Accessing-Qlikview-data-from-external-process/m-p/203736#M1207324 2009-11-06T04:12:24Z Accessing Qlikview data from external process https://community.qlik.com/t5/QlikView/Accessing-Qlikview-data-from-external-process/m-p/203737#M1207325 <HTML><HEAD></HEAD><BODY><P>Right there is no mechanism to externally query the data inside a QlikView document</P></BODY></HTML> Fri, 06 Nov 2009 04:18:54 GMT https://community.qlik.com/t5/QlikView/Accessing-Qlikview-data-from-external-process/m-p/203737#M1207325 Qlik_Trigg 2009-11-06T04:18:54Z Accessing Qlikview data from external process https://community.qlik.com/t5/QlikView/Accessing-Qlikview-data-from-external-process/m-p/203738#M1207326 <HTML><HEAD></HEAD><BODY><P>However with the API, I could manipulate a selection criteria and export a tables contents to a file, correct?</P></BODY></HTML> Fri, 06 Nov 2009 04:24:23 GMT https://community.qlik.com/t5/QlikView/Accessing-Qlikview-data-from-external-process/m-p/203738#M1207326 2009-11-06T04:24:23Z Accessing Qlikview data from external process https://community.qlik.com/t5/QlikView/Accessing-Qlikview-data-from-external-process/m-p/203739#M1207327 <HTML><HEAD></HEAD><BODY><P>yes you should be able to achieve this using the combination of API and export</P></BODY></HTML> Fri, 06 Nov 2009 06:27:19 GMT https://community.qlik.com/t5/QlikView/Accessing-Qlikview-data-from-external-process/m-p/203739#M1207327 Qlik_Trigg 2009-11-06T06:27:19Z