3 Replies Latest reply: Jun 8, 2017 6:34 AM by Vineeth Pujari RSS

    load script calculate measure on dimenson in another table

    Andrea Giacomello

      Hello Experts!

      i would need to do this in the Load Script of Qlik Sense.

       

      I load a table (let's say TABLE1) with a SELECT statement with some numbers, and a TABLE2 with some specifications (again with a select statement). There is a key that connects the 2 tables.

       

      I would like to apply this formula on TABLE1: aggr(expression, dimensions), but the dimesion is on TABLE2 and numbers of the expression in TABLE1.


      what can i do?


      Thank you!