topic Use function in store into string in QlikView

Use function in store into string

Thu, 16 Feb 2012 13:54:29 GMT

Hello,

Does anyone know if it is possible to use a function when you use store into?

Let's say I want the filename to be NameOfFile_20120216.txt

When I try the following QV complains about an "Unknown file format specifier"

store * from Table into D:\QlikViewSystems\PCD\Web\3_Load\NameOfFile_'&today()&'.txt (txt, delimiter is ';');

Martin

ekech_infomotio — Thu, 16 Feb 2012 14:00:51 GMT

I wouldn't put any functions directly into the store-statement. But you can put your function into a variable

let vExportFilename = 'D:\QlikViewSystems\PCD\Web\3_Load\NameOfFile_' & today() & '.txt';

store * from Table into $(vExportFilename) (txt, delimiter is ';');

regards,

Edgar

jagan — Thu, 16 Feb 2012 14:05:32 GMT

Hi,

Assign the file path into a variable like this

LET fileName = 'D:\QlikViewSystems\PCD\Web\3_Load\NameOfFile_'&today()&'.txt (txt, delimiter is' & char(39)& ';' & char(39) & ')';

Now assign the filename

store * from Table into $(fileName);

Hope this helps you.

Regards,

Jagan.

giakoum — Thu, 16 Feb 2012 14:18:25 GMT

Both jagan and Edgar are correct, however you need to format the date otherwise the windows filesystem will not recognise this as a valid file name :

let vExportFilename = 'temp' & date(today(),'dd-mm-yy') & '.txt';

store temp into $(vExportFilename) (txt, delimiter is ';');

BS, Ioannis