Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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:

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
Highlighted
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.

Highlighted
MVP & Luminary
MVP & Luminary

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

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Highlighted
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