2 Replies Latest reply: May 25, 2017 5:10 AM by Luis Carmona Martínez RSS

    Max in-between 4 Dimensions

    Luis Carmona Martínez

      Hi,

       

      I have 4 dimensions that can have values from -40 to 40, and I need to calculate a new Dimension or value that should the Max from these absolut values of these 4 dimensions.

       

      Example:

       

      Client      Dimension1  Dimension2  Dimension3  Dimension4      ExpectedVALUE

      1              -1                -0.5                3                  -4                         4

      2              1                  0.75              3                   -10                        10

      3              2                  -3                  5                    -4                         5

       

      I was trying to produce something like Max( FABS(Dimension1),FABS(Dimension2),FABS(Dimension3),FABS(Dimension4)) but the Max Function only operates with 1 Dimension, so this formula is a nonsense.

       

      I would like  to get  a Set Analysis Function as desired solution.

       

      ¿Any ideas of how to achieve it?

       

      Using: QlikSense 3.1

      seversuits 10.3.5