topic Re: How to modify data if you only have .qvw file ? in QlikView

How to modify data if you only have .qvw file ?

Wed, 02 May 2012 22:33:57 GMT

I have downloaded qvw file from the client site which has a dashboard with chart and tables. I need to modify some of these data to see what if scenario and to see how it will look when reloaded.

For example current dashboard has regions for sales . I want to replace them with city names. I canexport region data to excel sheet and change the name just to see how it looks. However, I don't kmow how to reload back and keep the relationship.

How to modify data if you only have .qvw file ?

rbecher — Thu, 03 May 2012 08:19:48 GMT

Hi,

if you have the load script you could load your changed data with a Partial Reload. Therefor you have to add "REPLACE" before the LOAD command for the table(s) you want to replace with your data.

Ralf

How to modify data if you only have .qvw file ?

danielrozental — Thu, 03 May 2012 16:58:24 GMT

Just an idea, do a binary load on the QVW, export all tables to QVDs then clear the orignal QVW script and load the QVDs.

You can change any info in the final script.

Re: How to modify data if you only have .qvw file ?

rwunderlich — Fri, 04 May 2012 03:19:50 GMT

You can binary load an existing qvw and spin the tables out to csv oe qvd files with this script.

BINARY your.qvw;

Directory c:\temp\extract;

FOR i = 0 to NoOfTables()-1

LET vTableName = TableName($(i));

LET vOutfile = '$(vTableName).csv';

STORE [$(vTableName)] INTO [$(vOutfile)] (txt);

NEXT i

If you want QVDs instead of CSV, change the file extension on line 5 and the (txt) to (qvd) on line 6.

-Rob

http://robwunderlich.com

How to modify data if you only have .qvw file ?

Fri, 04 May 2012 16:43:47 GMT

How can I do binary load? I tried putting statement in basic script - c:\xyz.qvw

Re: How to modify data if you only have .qvw file ?

rwunderlich — Fri, 04 May 2012 18:51:22 GMT

Binary must be the first statement in script. See the Help or Ref Guide for BINARY statement.

-Rob

How to modify data if you only have .qvw file ?

Sat, 05 May 2012 01:06:58 GMT

Got .qvw loaded ad binary. How to export to qvd? Export shows two options only -Export sheet image and Export Document layout. Export Document Layout creates xml files. Are they .qvd?

Re: How to modify data if you only have .qvw file ?

rwunderlich — Sun, 06 May 2012 23:08:23 GMT

The script I posted above will export all tables to CSV files after the binary load. To export to QVD, just make a couple changes.

Directory c:\temp\extract;

FOR i = 0 to NoOfTables()-1

LET vTableName = TableName($(i));

LET vOutfile = '$(vTableName).qvd';

STORE [$(vTableName)] INTO [$(vOutfile)] (qvd);

NEXT i

Re: How to modify data if you only have .qvw file ?

Mon, 07 May 2012 05:29:17 GMT

Hi Rob,

I would like to be able to delete already loaded tables (binary qvw) and retrieve tables from other qvw.

What do you recommend?

Thanks in advance,

Aldo.

Re: How to modify data if you only have .qvw file ?

rwunderlich — Mon, 07 May 2012 16:00:01 GMT

I'm not clear on the question. Could you explain a little more?

-Rob

Re: How to modify data if you only have .qvw file ?

Michael_Tarallo — Tue, 08 May 2012 11:41:03 GMT

Hello Mavrik12 - you may want to take a look at these posts in more detail:

expressor software has the ability to reverse engineer a .QVW file and extract the field table metadata from it to create an expressor QlikView schema. Then you can use the exported Excel data that you took from the QlikView export and use that as an input surce to create an Excel Schema to be used in an expressor Dataflow. You can then map the source input to the QlikView Schema and write out to a QlikView .QVX file using expressor. The new .QVX file will now be your new source of data that you can reload into your existing .qvw.

I actually run through this scenario in the video - except I use expressor to extract data from Salesforce instead of Excel.

The nice thing about this is that it is all graphical where no code is needed. It also creates a great way to create test scenarios such as the one you mentioned.

http://community.qlik.com/docs/DOC-2941

Watch the video - directly here:

http://community.expressor-software.com/blogs/mtarallo/52-expressor-3-6-qlikview-integration.html

I feel this may be able to help you and quite easily.

Here are some direct links:

http://market.qlik.com/expressor-for-qlikview.html

http://qlikviewexpress.expressor-software.com/

BTW - here is what is coming this summer:

expressor QlikView connector:

http://community.expressor-software.com/blogs/mtarallo/59-expressor-preview-next-level-qlikview-integration-qlikview-connector.html

Let me know if you have any questions.

Mike Tarallo

expressor