topic Re: Macro in Load Script appears as error in QlikView

Macro in Load Script appears as error

steeefan — Thu, 17 Dec 2015 10:29:48 GMT

Hi everyone,

I noticed a strange behaviour of QlikView 12 considering macros in load scripts.

QV 12 underlines the part of the script where the macro is called as to highlight that this part of the code is wrong and would cause an error. The script runs through however without any errors caused by the macro, at least in a test case. I'm not experiencing this behaviour in QV 11.2 SR12. The following screenshots shows the different behaviours:

Is anyone else experiencing this bevahiour?

-Stefan

Side note: I am not running QV 12 and QV 11.2 on the same machine.

Re: Macro in Load Script appears as error

steeefan — Fri, 18 Dec 2015 07:27:09 GMT

In the meantime I found a line like the one mentioned above which causes a load script to crash:








Trim(RegExFindFirst([Zuständiger Mitarbeiter], '[\w*üöä\-\s]*(?=\s\d)', '', 0)) AS zustMAClean,

The only thing I changed was upgrading from QV 11 SR12 to QV 12. I didn't change anyhting in the app itself.

Re: Macro in Load Script appears as error

rwunderlich — Wed, 20 Jul 2016 20:28:04 GMT

I reported the syntax coloring issue on April 26 and it was assigned Bug id QV-6773.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Help!!!!! RegExFind

bouderbc — Thu, 21 Mar 2019 16:30:03 GMT

Hello Experts ,

I have the same problem , i'm trying to enhance the performance of a dashboard , and i found some of these RegExFind function Highlighted in red in the script , i want to use other function who gives me the same result .

Example : RegExFind(Commentaire, '\d{2}-\d{2}-\d{2}-\d{2}-\d{2}', ';') as MOTS_INTERDITS

i've tryed to use Pick(wildmatch( Commentaire,'\d{2}-\d{2}-\d{2}-\d{2}-\d{2}'), ';') as MOTS_INTERDITS

i'm not sure that is working ...

Please HELP !!!

Thank you

Ali