topic Re: Create expression in Excel and use it in QlikView in QlikView

Create expression in Excel and use it in QlikView

jjordaan — Thu, 14 Jun 2012 15:37:48 GMT

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?

Re: Create expression in Excel and use it in QlikView

Thu, 14 Jun 2012 15:42:08 GMT

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

Re: Create expression in Excel and use it in QlikView

jjordaan — Thu, 14 Jun 2012 18:46:45 GMT

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

Re: Create expression in Excel and use it in QlikView

barryharmsen — Tue, 12 Mar 2013 21:11:04 GMT

Jeroen,

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

Cheers,

Barry

Re: Create expression in Excel and use it in QlikView

jjordaan — Tue, 12 Mar 2013 22:48:17 GMT

Barry

Thanks for your help.