AllowMacroFunctionsInExpressions Setting In Server

[d_pranskus]

Hi

I want to enable similar setting in server as AllowMacroFunctionsInExpressions = 1 in QlikView dektop. I need this to have user defined functions.

Could anybody help me find that setting if available

Thanks

Darius

[rmuhammad]

Here’s how to do it; keep in mind if this is a multi-node environment it will need to be done on each node running QVS.  Also, stopping the QlikView Server service will kick out any active users, so may need to plan accordingly.

1. Stop the QlikView Server service
2. Save a copy of the Settings.ini file before editing!
3. Edit the QlikView Server settings.ini file (you may need administrative priveledges to do this.  By default the file is here: C:\programdata\QlikTech\QlikViewServer\Settings.ini)
4. Add the following line inside of the [Settings 7] section: AllowMacroFunctionsInExpressions=1

  5. Restart the QlikView Server service