Urgent Help Pls: Database\QVD\

[#1]

Hi,

I've been going through the demo files. When I see the script editor, there is a path set to "Database\QVD\"

I want to access those QVD's for field values.

can any one help me where exactly the application targeting. And from where i can get those related QVDs ?

Please check the attachment for better insight.

Awaiting for reply,

Regards.

[ashfaq_haseeb]

Hi Bhasker,

You have to give complete path like

Let vPath = 'D:\Database\QVD\';

Regards

ASHFAQ

[sudeepkm]

which demo files you are referring. the script path indicates the Source document folder.

Do you know the location or folder structure ?

[#4]

Hi Ashfaq,

Its not what Ive done. Its the demo QVW.

Ive downloaded DEMO QVW file from the official Qlikview website .. Qlik Demos: See QlikView in Action | Demo.Qlik.Com

When I execute it , it works perfect. So I decided to play with values and make a new simple application for myself.

How ever, I couldn't figure out from where it is taking the qvd's and source files ..

It says

LastCells:

LOAD

  LastCell_ID,

     Network,

     Longitude,

     Latitude

FROM $(vPath)LastCells.qvd (qvd);

so obviously my next instinct would be checking what is set to vPath vairable.

And vPath Vairable is set to " Database\Qvd ", Please check the attached image above.

And I'm not sure , i have no clue , from where it is pulling the data.

Please do check the attachment.

Thankyou.

Regards.

[#5]

The location of your QVD´s are only something you would know.

And as stated before, you have to put a qualified unc path to the qvds, for it to work

[#6]

It is the path where your QVW file was, Example If your QVW is in d:\ABC then the path will be d:\ABC\Database\QVD\

Regards,

Chinni Kanna

[#7]

Hi Sudeep, i am refereing to  the link "us-b.demo.qlik.com/detail.aspx?appName=Call%20Detail%20Record%20Analysis.qvw"

Ive downloaded it . Only the QVW of size 70mb has been downloaded ..

I understand that we need some path to pull the data .. But i was wondering , what the hell with these demos.

Only a QVW is available for download, i see no download links to download the qvd's. But this application works fine.

there should be some logic behind. i just want to know how to edit the values of those fields or how to edit the qvds.

..

Once you please download that demo .. and check in script editor .. you will understand.

[sudeepkm]

when you download a qvw from Access Point or in case of demo files from the QlikView site then the QVW only comes not the source data files or the full source folder structure.

If you want to extract the data from these qvws to your local you can create table boxes with data from specific tables and then export to excel.

or if you want the data model of the qvw and have your own visualization then you can binary load the qvw file in to your qvw.

[#9]

The file has all the needed data already in it, that´s why it is 70 MB. The QVD´s are only needed to reload the data.

In general you create the QVD using: STORE <path> INTO <filename>.qvd after i.e. an SQL LOAD statement  , where the path is the path on you hard drive. Most of the times you will store the QVD files on the server. So the qvw gets reloaded on the server and the end user can download the file with all the data already included (or just open in in the web client).

I hope this helps you.

cheers

[Anonymous]

Select computer  and use search box on right top corner of page ,give  Database or QVD or saved qvdname etc.,If it is not hidden folder  it will show up path where they are stored by searching whole computer.

Usually when i forget where i stored my files, I do this... may be it helps for you.