Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
steeefan
Luminary
Luminary

Macro in Load Script appears as error

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:

load-script-macro-12-vs-11.2.png

Is anyone else experiencing this bevahiour?

-Stefan

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

3 Replies
steeefan
Luminary
Luminary
Author

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.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

bouderbc
Creator
Creator

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