how to download the movie xls files used in the sample qvw

[#1]

Can anyone help me to know "how to download the movie xls files used in the sample qvw"

[#2]

Hi Guljeet,

Please see this thread where Rob answers the question. The .xls files are not available on the site, but  he gives two options: one is to binary load the .qvw file if your intent is to reuse the data as is from scratch in another QlikView app. The other is to go to imdb.com (where the source of the data is) and use their APIs to extract the data.

Thanks,
Kevin

[Anonymous]

Hi Guljeet,

As Kevin mentioned you can do a binary load from the Movie Database and then you could store the tables into qvd files. You would only have to do this once and then you would have a set of qvds to use as you wish.

[Agis-Kalogiannis]

In addition to Nils' answer, if you definitely want this data in xls format, you could easily create one or more table box objects, with data from the data model, and export everything into excel..

[#5]

Thanks a Lot!

I got it. We can do it by creating the Table objects.

But, Still I am not clear with the Binary Load approach.

I am very new to QlikView. Can you please also suggest with a simple example that, How can I create the QVD files using the existing QVW file.

Regards,

Guljeet

[Agis-Kalogiannis · Accepted solution]

Since a QVW file contains all the data, you can use the Binary statement (or the QlikView File button to the bottom right hand side of your script editor, which does exactly the same) to import the data from another QlikView file into your application Guljeet,

If you import the data and you have all the tables available, then you can use the STORE command to create QVD files.

STORE tablename INTO filename.QVD;

Regards

Agis