Discussion board where members can learn more about Qlik Sense App Development and Usage.
In my script I want to store the filename as every day, for example:
store * from Precio_Crudo_GasNatural_OPEP into 'lib://QVDs/Precio_Crudo_GasNatural_OPEP_$(vFecha).qvd'(qvd);
but the result is : Precio_Crudo_GasNatural_OPEP_=Now().qvd
and I want to store like that:
I create a variable vFecha=Now() but how do I use that as part of the filename?
Go to Solution.
let vFecha = date(today(), 'DD.MM.YYYY'); // a slash isn't an allowed char within a filename
Run the below script you will have your best solution:
=> create a new folder connection with name test
Let vtoday = date(today());
LOAD * inline [
"First name"|"Last name"|Amount|"Has cellphone"
Peter|Franc|10|Yes ] (delimiter is '|');
store Names into "lib://test/$(vtoday).qvd"(QVD);
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Please replace only test with your connection name and run the script