Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variables

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

13 Replies
rustyfishbones
Master II
Master II

Ok so maybe remove the filename part

so just say

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

Not applicable
Author

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

Not applicable
Author

No because path and file are correct

doesn't mean a file exists

Chris

Not applicable
Author

OK

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