Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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.

10 Replies
Michael_Tarallo
Employee
Employee

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-inte...

Let me know if you have any questions.

Mike Tarallo

expressor

Regards,
Mike Tarallo
Qlik