topic Re: find the maximum value across field in QlikView

find the maximum value across field

sivarajs — Tue, 22 May 2012 05:42:34 GMT

Hi,

i have 4 fields and i need to get field having maximum value

eg;

fieldname1 - 12

fieldname2 - 24

fieldname3 - 09

fieldname4 - 06

fieldname2 has the maximum value and i need to get this field either in script or in chart

Thanks

Sivaraj S

Sokkorn — Tue, 22 May 2012 06:11:32 GMT

Hi Sivaraj S,

Can you provide a sample data source with row and column and the result you looking for?

Regards,

Sokkorn

sivarajs — Tue, 22 May 2012 06:27:46 GMT

see the xls i explained what i want

Tue, 22 May 2012 09:05:36 GMT

if(f1>f2 and f1>f3 and f1>f4, 'f1',

if(f2>f1 and f2>f3 and f2>f4, 'f2',

if(f3>f1 and f3>f2 and f3>f4, 'f3',

if(f4>f1 and f4>f2 and f4>f3, 'f4'

)

) as MaxFiled

sivarajs — Tue, 22 May 2012 09:13:48 GMT

thanks for the solution its good i have already tried that .If we have some 3 or 4 fields then its ok but it should be generic

any idea