Use SET in INCLUDE

[Anonymous]

Hello qlikers 🙂 ,

is there a option use a SET variabel in an INCLUDE?

In my qlik sense

SET $savePath = 'lib://Test/';
$(MUST_INCLUDE=[lib://Test/test.qvs]);

 My include

FOR vCount = 0 to NoOfTables()-1

LET vTableName = TableName($(vCount));

STORE $(vTableName) INTO $(savePath)$(vTableName).qvd (qvd);

NEXT vCount

I want to save all the qvds in Test/QVD.qvd . Can I use the SET variabel in my include ? Thank you in advance! 🙂

Looking forward to reading some answers. 

[rwunderlich · Accepted solution]

This should work. You might want to add some brackets to handle cases where the tablename contains spaces.

STORE $(vTableName) INTO [$(savePath)$(vTableName).qvd] (qvd);

-Rob

[Anonymous]

Thank you for your answer! But I got this error message! 🙂

[rwunderlich]

You are receiving that error because there is no lib in the path, I believe because of inconsistent variable spelling.  In your original post you spelled it:

SET $savePath

Then when you referred to in the STORE you used just "savePath".  Make sure they match.

-Rob