Max in-between 4 Dimensions

[luisccmm]

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

[marcus_malinow · Accepted solution]

Try using RangeMax(FABS(Dimension1),FABS(Dimension2),FABS(Dimension3),FABS(Dimension4))

[luisccmm]

Thank you very much marcusmalinowinfosys‌ !!!

It was a great help!!