Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

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:


Is anyone else experiencing this bevahiour?


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

3 Replies
Contributor II
Contributor II

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.

MVP & Luminary
MVP & Luminary

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





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