getting count of records in QVD

[Anonymous]

Hi,

I am new to qlikview. I am validating a records in QVD with database.

initially i have created

Let a=QvdNoOfRecords ('Marketing funnel QVW\New Data\dim_page.qvd');

Directory;

LOAD * FROM

[Marketing funnel QVW\New Data\dim_page.qvd]

(qvd);

after that i took one text object and try to call this variable in text, but it is dispalying only variable name. Pls can anybody help on this one.

Regards,

Kumar

[alexandros17]

Probably you have to load the qvd at first, try with

Directory;

LOAD * FROM

[Marketing funnel QVW\New Data\dim_page.qvd]

(qvd);

Let a=QvdNoOfRecords ('Marketing funnel QVW\New Data\dim_page.qvd');

[MK_QSL]

hope you are using

=a

in text object

[MK_QSL]

No Alessandro, that should be in case if you are interested in number of rows in any loaded table..

Let b = NoOfRows('TableName');

[Anonymous]

I am uploading qvw . can u look into this one.

Regards,

Kumar !

[MK_QSL]

I have changed to one of my QVD and it's working

In your case variable a is not generated at all.

QvdNoOfRecords should work with both absolute and relative path. But for checking purpose, can you provide absolute path (full path) as I have used?

Let a = QvdNoOfRecords ('C:\Manish\Applications.qvd');

Directory;

LOAD * FROM

(qvd);

[Anonymous]

And one more doubt on this one. Is this the same way to find out records count in qvx files as we do for qvd.

Regards,

Kumar