topic Re: Data extraction using qlikview in QlikView

Data extraction using qlikview

Wed, 28 Nov 2012 21:15:15 GMT

I have a requirement to extract large sums of transactional data from qlikview.

How can I acheive it without having to load in a QVW file and be able to run in background?

Re: Data extraction using qlikview

rwunderlich — Thu, 29 Nov 2012 16:44:35 GMT

Could you provide a bit more detail please?

-Rob

Re: Data extraction using qlikview

Thu, 29 Nov 2012 17:43:08 GMT

What I mean to say is that can we do data extraction like we use to do in a relational database in a batch mode?

Re: Data extraction using qlikview

shree909 — Thu, 29 Nov 2012 23:06:57 GMT

yes u can do but the problem u will have is the size of the qvw will be increased. if u have less data it works fine but if u have huge amounts of data then it wont be fast....

Re: Data extraction using qlikview

Fri, 30 Nov 2012 05:31:57 GMT

use cubes

Re: Data extraction using qlikview

Anonymous — Fri, 30 Nov 2012 05:42:30 GMT

Still confusing.

You want to get data out of your database and into QlikView?

The easiest approach would be to use QlikView Server/Publisher to schedule loading of data during non peak hours, like at night for example.

You can set up incremental loads in QlikView using QVD files so you only need to pull the latest transactions from the database every time you're refreshing your documents.