Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

kumarreddy257
Contributor

getting count of records in QVD

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

6 Replies

Re: getting count of records in QVD

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');

MVP
MVP

Re: getting count of records in QVD

hope you are using

=a

in text object

MVP
MVP

Re: getting count of records in QVD

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

Let b = NoOfRows('TableName');

kumarreddy257
Contributor

Re: getting count of records in QVD

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

Regards,

Kumar !

MVP
MVP

Re: getting count of records in QVD

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);

kumarreddy257
Contributor

Re: getting count of records in QVD

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

Community Browser