Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

luisccmm
Contributor

Max in-between 4 Dimensions

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

Tags (1)
1 Solution

Accepted Solutions
marcus_malinow
Valued Contributor III

Re: Max in-between 4 Dimensions

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

2 Replies
marcus_malinow
Valued Contributor III

Re: Max in-between 4 Dimensions

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

luisccmm
Contributor

Re: Max in-between 4 Dimensions

Thank you very much marcusmalinowinfosys‌ !!!

It was a great help!!

Community Browser