Discussion board where members can get started with Qlik Sense.
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.
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
Go to Solution.
Try using RangeMax(FABS(Dimension1),FABS(Dimension2),FABS(Dimension3),FABS(Dimension4))
Thank you very much marcusmalinowinfosys !!!
It was a great help!!