topic Re: Urgent Help Pls: Database\QVD\ in QlikView

Urgent Help Pls: Database\QVD\

Tue, 15 Jul 2014 11:36:10 GMT

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.

Re: Urgent Help Pls: Database\QVD\

ashfaq_haseeb — Tue, 15 Jul 2014 11:42:03 GMT

Hi Bhasker,

You have to give complete path like

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

Regards

ASHFAQ

Re: Urgent Help Pls: Database\QVD\

sudeepkm — Tue, 15 Jul 2014 11:45:36 GMT

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

Do you know the location or folder structure ?

Re: Urgent Help Pls: Database\QVD\

Tue, 15 Jul 2014 11:54:00 GMT

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.

Re: Urgent Help Pls: Database\QVD\

Tue, 15 Jul 2014 11:54:57 GMT

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

Re: Urgent Help Pls: Database\QVD\

Tue, 15 Jul 2014 11:57:05 GMT

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

Re: Urgent Help Pls: Database\QVD\

Tue, 15 Jul 2014 11:59:13 GMT

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.

Re: Urgent Help Pls: Database\QVD\

sudeepkm — Tue, 15 Jul 2014 12:12:50 GMT

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.

Re: Urgent Help Pls: Database\QVD\

Tue, 15 Jul 2014 12:15:53 GMT

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

Re: Urgent Help Pls: Database\QVD\

Anonymous — Tue, 15 Jul 2014 16:35:39 GMT

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.

Re: Urgent Help Pls: Database\QVD\

Wed, 16 Jul 2014 01:33:59 GMT

Hi Praveena,

Ive been researching on this yesterday.Unlike CALLS, Qliktech has another licencing which only they have the access to. It is Embedded licencing. Which means,it helps you to stay in control of your application.

Do some r and d ,you will be amazed ..

Cheers,

Kumar.

Re: Urgent Help Pls: Database\QVD\

NZFei — Wed, 16 Jul 2014 02:23:40 GMT

Binary reload the application itself and then export the tables to QVD files.

And then you have those QVD files.

Fei

Re: Urgent Help Pls: Database\QVD\

Wed, 16 Jul 2014 16:27:46 GMT

U R amazing..Brilliant !!