8 Replies Latest reply: Oct 18, 2018 9:17 AM by Petter Skjolden RSS

    How to do Matrix Multiplication in QlikSense ?

    Sushant Jain

      Matrix A

       

      A1A2A3A4A5
      124010

       

      Matrix B

       

      B1B2B3B4B5
      112123
      234012
      356201
      412021
      513012

       

       

      c11 = 2 x 1 + 4 x 3 + 0 x 5 + 1 x 1 + 0 x 1 = 15

       

      C1C2C3C4C5
      1150000

       

      c12 = 2 x 2 + 4 x 4 + 0 x 6 + 1 x 2 + 0 x 3 = 22

       

      C1C2C3C4C5
      11522000

       

      c13 = 2 x 1 + 4 x 0 + 0 x 2 + 1 x 0 + 0 x 0 = 2

       

      C1C2C3C4C5
      11522200

       

      c14 = 2 x 2 + 4 x 1 + 0 x 0 + 1 x 2 + 0 x 1 = 10

       

      C1C2C3C4C5
      115222100

       

      c15 = 2 x 3 + 4 x 2 + 0 x 1 + 1 x 1 + 0 x 2 = 15

       

      C1C2C3C4C5
      1152221015

       

       

       

      Result:

       

      C1C2C3C4C5
      1152221015

       

       

      How to achieve such multiplication? Can i do it backend ? In excel it can be implemented using MMULT fucntion