Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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');
hope you are using
=a
in text object
No Alessandro, that should be in case if you are interested in number of rows in any loaded table..
Let b = NoOfRows('TableName');
I am uploading qvw . can u look into this one.
Regards,
Kumar !
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);
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