4 Replies Latest reply: Mar 12, 2013 6:48 PM by Jeroen Jordaan RSS

    Create expression in Excel and use it in QlikView

    Jeroen Jordaan

      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?