Discussion Board for collaboration related to Creating Analytics for QlikView.
I would like to check is a filename exists in a directory
depending on it I want to show the filename in a diagram
within the script I have found all JPG-Files
LET sDir = 'C:\Users\bumin\pictures\'; // Directory to look through
LET sFile = '*.JPG'; // Searchpattern
LET sSearchPattern = sDir & sFile;
// =================== Scan through directory and list all possible files
FOR EACH vFile in FileList (sSearchPattern)
'$(vFile)' AS FileFound
now I want to check if a spcific filename does exists in FileFound
I have tried several functions but I didn' got it.
can someone help?
I have enterred the followinh fomula:
but then I get each record twice