Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
This is a line I'm trying to put in my script to check an early if statement in debug.
set vTemp2= upper(left(filename('$(FoundFile)'),len(filename('$(FoundFile)'))-21));
The FoundFile is a loop parameter.
I have this line one step earlier :
set vTemp= '$(FoundFile)';
It works and gives me a path to the file.
but the line I showed you doesnt give me a result and what I get in vTemp2 is a long string of :
"upper(left(filename('$(FoundFile)'),len(filename('$(FoundFile)'))-21))"
where am I wrong?
Thanks,
Boris
LET vTemp2= upper(left(filename('$(FoundFile)'),len(filename('$(FoundFile)'))-21));
Quote from Qlikview help
The syntax is:
let variablename=expression
Note that the word let may be omitted.
Set x=3+4;
Let y=3+4;
z=$(y)+1;
$(x) will be evaluated as '3+4 '
$(y) will be evaluated as '7'
$(z) will be evaluated as '8'
Example:
Let T=now( );
$(T) will be given the value of the current time.
regards.janne
LET vTemp2= upper(left(filename('$(FoundFile)'),len(filename('$(FoundFile)'))-21));
Quote from Qlikview help
The syntax is:
let variablename=expression
Note that the word let may be omitted.
Set x=3+4;
Let y=3+4;
z=$(y)+1;
$(x) will be evaluated as '3+4 '
$(y) will be evaluated as '7'
$(z) will be evaluated as '8'
Example:
Let T=now( );
$(T) will be given the value of the current time.
regards.janne