Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Jeroen,
Have a look at this: http://www.qlikfix.com/2011/09/21/storing-variables-outside-of-qlikview/
Cheers,
Barry
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
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
Jeroen,
Have a look at this: http://www.qlikfix.com/2011/09/21/storing-variables-outside-of-qlikview/
Cheers,
Barry
Barry
Thanks for your help.