topic Re: I'm facing a big issue I need help in QlikView

I'm facing a big issue I need help

Thu, 24 Jul 2014 13:33:36 GMT

Hi to everyone,

I'm a new qlikview developper, am facing an issue and I need your help.

I get the links (in the field SourceFile) of all my word files inside a folder using the following procedure:

Set vConcatenate = ;

FileList:

LOAD

'' AS SourceFile

AUTOGENERATE 0;

sub ScanFolder(Root)

for each FileExtension in 'doc'

for each FoundFile in filelist( Root & '\*.' & FileExtension)

FileList:

LOAD '$(FoundFile)' as SourceFile

AUTOGENERATE 1;

Set vConcatenate = Concatenate;

next FoundFile

next FileExtension

for each SubDirectory in dirlist( Root & '\*' )

call ScanFolder(SubDirectory)

next SubDirectory

end sub

Call ScanFolder('\\mboko\tdb\Indicateurs') ;

then I test if those links contain certain values (those values are in the field INDICATOR) through the following expression:

=if(Index(SourceFile,INDICATEUR) <> 0,SourceFile)

when I put this expression in a selection list I got the good results

I decided then to create a variable vUrl which contain the expression above. The problem I face is that this variable doesn't output any result. I don't know what I'm doing wrong.

Thanks in advance

Re: I'm facing a big issue I need help

Thu, 24 Jul 2014 14:19:31 GMT

Nobody to help me ?

Re: I'm facing a big issue I need help

gmoraleswit — Thu, 24 Jul 2014 15:01:47 GMT

have you tried this: $(vUrl) ?

Re: I'm facing a big issue I need help

Thu, 24 Jul 2014 15:05:23 GMT

Yes, I've already tried this but it doesn't work

Re: I'm facing a big issue I need help

gmoraleswit — Thu, 24 Jul 2014 15:13:23 GMT

Can you upload an example?

Re: I'm facing a big issue I need help

Thu, 24 Jul 2014 15:32:51 GMT

Re: I'm facing a big issue I need help

m_woolf — Thu, 24 Jul 2014 18:18:30 GMT

The expression doesn't return a single value. It returns a set or records.

If you create a list box and use the variable as the expression, you will probably see the correct results.

Re: I'm facing a big issue I need help

gmoraleswit — Thu, 24 Jul 2014 18:54:23 GMT

Hum...try deleting the '=' sign in the variable definition

Re: I'm facing a big issue I need help

Thu, 24 Jul 2014 20:36:55 GMT

If you defined your vUrl variable inside the UI in the Variable Overview screen, wrap the expression in single quotes:

='if(Index(SourceFile, INDICATOR) <> 0,SourceFile)'

Update:

Or try to add the expression in the script:

SET vUrl = if(Index(SourceFile, INDICATOR) <> 0,SourceFile);