Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
In QlikView version 11 script, the five QVD file functions were not impacted by use of the Directory statement.
Relative paths given to these functions were always relative to the qvw file, not the current Directory setting.
This is different than the other file functions like FileSize() which considered paths to be relative to the current Directory setting.
In QlikView version 12, the QVD File functions have been changed to respect the Directory setting, making them consistent with the other functions.
However, this change means that your original QlikView 11 script may no longer work in QlikView 12 without modifications.
Here is how you may have coded a script sequence in QlikView 11:
DIRECTORY data; STORE Customer INTO Customer.qvd; LET vCustomerRows = QvdNoOfRecords('data\Customer.qvd');
This will not work in QlikeView 12. The function will be looking for the qvd in “data\data\Customer.qvd”.
There will be no script error, but the value of “vCustomerRows” will be null.
Because QlikView 12 respects the Directory, the correct syntax for QlikView 12 would be “QvdNoOfRecords(‘Customer.qvd’).
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join UsSearch Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a caseExperiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.
Call Us