topic Copying a qvw and filtering data in QlikView

Copying a qvw and filtering data

Wed, 29 Sep 2010 08:52:52 GMT

Hi,

We have a few qvw's that contain data for multiple companies (companies are a key across the qvw). We need to copy these qvw files to single company qvw files after the extract (so as not to do an extract from source data again). I can schedule the qvw to be copied to another qvw name, but then how can I write a script to strip out the relevent company for this new copied one? What is the best method?

Regards,

John

Copying a qvw and filtering data

johnw — Thu, 30 Sep 2010 02:32:01 GMT

The BEST method is probably to use QlikView Publisher. On the task, there is a Reduce tab. Do a loop and reduce on the Customer field. That should create one document per Customer.

If you don't have QlikView Publisher, and you only have a few customers, you might be able to do it like this:

BINARY MainDocument.qvw;
INNER JOIN (MainTable)
LOAD 'Bob Jones' as Customer
AUTOGENERATE 1;

And repeat with a separate QVW and script for every customer.

There are probably other approaches that would work too.

Copying a qvw and filtering data

Thu, 30 Sep 2010 08:39:42 GMT

Thanks for the advice John. I don't have publisher, but Qlikviw professional. I am testing out your solution.

Thanks,

John