topic Re: Qvd's in QlikView

Qvd's

Anonymous — Mon, 05 Jan 2015 06:00:35 GMT

How to check the data has loaded successfully from qvd

Re: Qvd's

Mon, 05 Jan 2015 06:02:02 GMT

Check This

Re: Qvd's

its_anandrjs — Mon, 05 Jan 2015 06:23:09 GMT

Hi,

Try one of this way to check no of rows loaded or not for this put RowNo() function in the QVD load.

Load

Rowno() as RowCount

Field1,

Field2,

From Source;

Regards

Anand

Re: Qvd's

djsampat — Mon, 05 Jan 2015 09:03:56 GMT

Please the QVD in the same folder as the QVW and you can run the following:-

Sample:

LOAD *

FROM

[test.qvd]

(qvd);

Sample2:

LOAD *

FROM

(qvd);

Sample3:

LOAD *

FROM

[..\test.qvd]

(qvd);

If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer

Regards

Dhruv

Re: Qvd's

Anonymous — Mon, 05 Jan 2015 09:06:24 GMT

after successfully loaded data into application use the count function and count the number of rows .

Re: Qvd's

its_anandrjs — Mon, 05 Jan 2015 09:08:25 GMT

Hi,

What are the conditions where you confirm the data is loaded successfully from the QVD.

Regards

Anand

Re: Qvd's

Anonymous — Mon, 05 Jan 2015 09:11:47 GMT

You can see at the time of Reloading the " Script Execution Progress" window to know, how many records have been fetched.

Hope this helps.

Best,

Re: Qvd's

Anonymous — Mon, 05 Jan 2015 09:14:34 GMT

Use the Trace function after the store command in QVD.

Trace << Data Load completed successfully.

It will prompt you at the time of execution finished.

Re: Qvd's

engishfaque — Mon, 05 Jan 2015 10:22:02 GMT

Dear RGV,

I'm going to tell you three ways, you can deal with it. Kindly find attached document before going to listed below techniques.

1. Uncheck to check box "Close when finished" => see attached "Technique 1.png"

2. Log file => Generate log file and check it, => see attached "Technique 2.png"

3. Function => Write a subroutine for "RowCount" => see attached "RowCountExample.qvw", "RowCount.qvs" and "RowCountExample.png"

Kind regards,

Ishfaque Ahmed