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!