Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

satishkamath
Contributor II

Max value out of five columns

Hi

I have data as below

Location  V1  V2   V3   V4   V5

USA          2    0      0     3      0

Canada     0    0      4     7     1

Mexico      0    4     3     2      0

India          2    2    0     0      0

The goal is as below adding last column with highest value from column through V1 to V5

Location  V1  V2   V3   V4   V5 Value

USA          2   0      0     3      0    3

Canada     0   0      4     7     1     7

Mexico      0    4     3     2      0    4

India          2    2    0     0      0     2

Thanks in advance for your guidance

4 Replies

Re: Max value out of five columns

Try RangeMax()

RangeMax(V1, V2, V3, V4, V5)

satishkamath
Contributor II

Re: Max value out of five columns

Hi Sunny

Thanks for suggestion

Highlighted

Re: Max value out of five columns

Did it work or not?

satishkamath
Contributor II

Re: Max value out of five columns

Hi Sunny

Sorry for late reply, some problem in my PC.

But yes it works nice.

Thanks for your suggestion

Sorry for late reply again