5 Replies Latest reply: Jun 29, 2015 3:38 AM by Mark Munich RSS

    moving Expressions from frontend into scrpting layer(Datamodel)

    Mark Munich

      Hello Qlik's,

       

      Could some one suggest me the best way to move the complex Forumulas in the frontend Analysis layer to the Scripting layer. For example: if the expression in the diagram uses the Data from 3 or 4 different Tables , What is the best way to write the expression in scripting layer by fetching data from 3-4 tables. I though of bringing the fields/ dimensions which i require in the forumula to one table  by using the mapping tables and read all the values from different tables and then perform the calculation in one table.

       

      Is it the only possible way or is there any other alternative.

       

      Thanks & Regards

      Marks