Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to save the QVD's to a path by jumping th folder i am a bit confused to how do we do it in Qliksense .
Belw is the path from where i have fetched the data(QVD)
FROM [lib://DEV - Dept- Qliksense/QVD/Sales.qvd]
I want to know how do i store store the QVD's by jumping the folder with above path I want to mentione only
../Qliksense/QVD/sales.qvd(qvd);
Thanks in Advance
You can't* use relative path in Qlik Sense. You need to use the LIB.
If the LIB is to change often then you could store it as a variable in the beginning of the script and then use the variable thereafter.
SET vLib = lib://DEV - Dept- Qliksense/;
LOAD * FROM [$(vLib)QVD\sales.qvd] (qvd);
STORE myTable into [$(vLib)QVD\myTable.qvd] (qvd);
*) it might be possible with relative path if you on Qlik Sense System level changes from Standard mode to Legacy mode. Read: Disabling standard mode ‒ Qlik Sense on Windows and Legacy vs. Standard Mode in Qlik Sense: Explainer and Security Considerations and
You can't* use relative path in Qlik Sense. You need to use the LIB.
If the LIB is to change often then you could store it as a variable in the beginning of the script and then use the variable thereafter.
SET vLib = lib://DEV - Dept- Qliksense/;
LOAD * FROM [$(vLib)QVD\sales.qvd] (qvd);
STORE myTable into [$(vLib)QVD\myTable.qvd] (qvd);
*) it might be possible with relative path if you on Qlik Sense System level changes from Standard mode to Legacy mode. Read: Disabling standard mode ‒ Qlik Sense on Windows and Legacy vs. Standard Mode in Qlik Sense: Explainer and Security Considerations and