Create expression in Excel and use it in QlikView

[jjordaan]

Hello everyone,
I would like to develop the following thiing.
I want to create all my KPIs and the corresponding expression in Excel or another central location.
In my dashboard when I'm creating an expression I want to refer to the created expression like Sum (SalesLineAmount * Currency Factor).
I tried this with the function field value but that did not work because qlikView sees it as text.

Does anyone know how I can do it?

[#2]

If you use a file use the include command in the load script: -

$(Include=$(_rootPath)\Script\Business\INIT_VAR_GLOBAL.txt)

in this test file use this syntax: -

SET vKPI1 = X + Y +Z ETC

when loaded they will be variable formula to use

[jjordaan]

Hi Felim,

Thanks for looking into this.

Do you know if it is also possible with an Excel file?

The reason for this question is thatmy translations and comments are also in this Excel file.
And I want that the customer can change this Excel.

Thanks for your help

[barryharmsen · Accepted solution]

Jeroen,

Have a look at this: http://www.qlikfix.com/2011/09/21/storing-variables-outside-of-qlikview/

Cheers,

Barry

[jjordaan]

Barry

Thanks for your help.