topic Re: Variables in QlikView

Variables

Fri, 25 Apr 2014 08:54:51 GMT

Hi everybody

i'm facing a strange issue or misunderstanding

When I

LOAD * FROM [$(PathQVD)\$(FileNameQVD).qvd] (qvd);

everyting's OK

BUT When i'm doing

LET v =filename([$(PathQVD)\$(FileNameQVD).qvd]);

my variable v is NULL

Any idea ?

Thnak you

Chris

Re: Variables

Fri, 25 Apr 2014 08:56:19 GMT

What exactly u want to store in variable v??

Re: Variables

maxgro — Fri, 25 Apr 2014 08:58:18 GMT

this is an example of using filename from online help

Load *, filename( ) as X from

C:\UserFiles\abc.txt

Will return 'abc.txt' in field X in each record read.

Re: Variables

MK_QSL — Fri, 25 Apr 2014 08:58:21 GMT

Try this

LET v =filename('[$(PathQVD)\$(FileNameQVD).qvd]');

Re: Variables

rustyfishbones — Fri, 25 Apr 2014 08:58:44 GMT

You don't need a variable

try

LOAD *,

FileName() as Filename

FROM [$(PathQVD)\$(FileNameQVD).qvd] (qvd);

Re: Variables

Fri, 25 Apr 2014 08:58:58 GMT

I want to check wether or not the file exists

so if i get a filename it does

Chris

Re: Variables

Fri, 25 Apr 2014 09:00:23 GMT

I did already, it doesn't

Chris

Re: Variables

Fri, 25 Apr 2014 09:00:52 GMT

Yes I do,

i don't want to load data, just check if the file exists

Chris

Re: Variables

rustyfishbones — Fri, 25 Apr 2014 09:04:37 GMT

Hi Chris,

You may want to use this instead

LOAD *,

FilePath() as Path

FROM [$(PathQVD)\$(FileNameQVD).qvd] (qvd);

This will give you the full path of where the file is located and the filename

Regards

Alan

Re: Variables

maxgro — Fri, 25 Apr 2014 09:06:16 GMT

for qvd file there are qvd file functions

answer here (and example)

Re: How can I check if a file exists ?

QvdCreateTime

Returns the XML-header time stamp from a QVD file if any (otherwise NULL).

The filename is the name of a QVD file, if necessary including path.

Examples:

QvdCreateTime('MyFile.qvd')

QvdCreateTime('C:\MyDir\MyFile.qvd')

Re: Variables

rustyfishbones — Fri, 25 Apr 2014 09:15:17 GMT

Ok so maybe remove the filename part

so just say

LET v = '$(PathQVD)\$(FilenameQVD)';

Re: Variables

Fri, 25 Apr 2014 12:13:31 GMT

Thank you Massimo

but i don't want only check qvd files.

the pb i don't understand is why LOAD works with my variable '$(PathQVD)\$(FilenameQVD) and WHY

LET v= '$(PathQVD)\$(FilenameQVD) returns null

Chris

Re: Variables

Fri, 25 Apr 2014 12:16:26 GMT

No because path and file are correct

doesn't mean a file exists

Chris

Re: Variables

Fri, 25 Apr 2014 12:18:32 GMT

i found why

FileName is the problem. Returns always NULL

FielSize returns a value if file exists and null if doesn't

Thnak you everybody for your help

Chris