Create folder if not available

[Anonymous]

Hello qlikers 🙂 ,

I want to create a folder in qlik sense script when the folder isn't created.

SET varPath = ' 'lib://Qlik/Transfer/Test/Backup';
LET varFolder = DocumentTitel();

IF ((varPath + varFolder) exist)
// do something
ELSE
create varPath + varFolder

How can I do that? Thank you in advance! 🙂 Looking forward to reading some answers.  

[anushree1]

You can use the below statement to check if the file is present :

let vfilechk= if(FileSize('lib://Folder_Conn/Data and Graph.xlsx')>0,1,0);

[Anonymous]

Thank you for your answer.  I check if the folder exist with

if FileTime($(vSavePathBackup)$(saveName))

 But how can I create this folder, when it doesn't exist?

Thank you agian! 🙂

[martinpohl · Accepted solution]

in former times (especially with QlikView 11.2 and lower) you could'nt write a file to a folder that doesn't exists.

Since QV 12, and so I think in actual versions of Qlik Sense it is also, a folder is created if not exists.

store table into LIB://qvd/VBRP/2020/VBRP_2020.qvd (qvd);

regards