Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Register for Events and Webinars directly from Qlik Community: http://bit.ly/2Vpnenx
Highlighted
Partner
Partner

Create expression in Excel and use it in QlikView

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?

1 Solution

Accepted Solutions
Highlighted
Luminary
Luminary

Re: Create expression in Excel and use it in QlikView

4 Replies
Highlighted
Not applicable

Re: Create expression in Excel and use it in QlikView

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

Highlighted
Partner
Partner

Re: Create expression in Excel and use it in QlikView

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

Highlighted
Luminary
Luminary

Re: Create expression in Excel and use it in QlikView

Highlighted
Partner
Partner

Re: Create expression in Excel and use it in QlikView

Barry

Thanks for your help.