topic Return field with highest value in QlikView

Return field with highest value

Anonymous — Thu, 07 Apr 2011 13:32:14 GMT

Thanks in advance for any replies.

I have a load which includes the fields below, indicating how old the record is in days and the value - so only one of these 5 fields can be populated with a value > '£0':

EXAMPLE
[0-30] - £0
[31-60] - £800
[61-90] - £0
[91-120] - £0
[>120] - £0

This means that the record is 31-60 days old with a value of £800
What I need is a function or code to recognise which of the 5 fields has the value > '£0'
rangemax returns the highest value of £800 which is ok but need to recognise which of the 5 fields this value is in.

Re. :Return field with highest value

vincent_ardiet — Thu, 07 Apr 2011 13:44:16 GMT

Hi,

Try with FirstSortedValue. You can obtain the age with the biggest amount.

Regards,

Vincent

Re. :Return field with highest value

Anonymous — Thu, 07 Apr 2011 13:53:09 GMT

Thanks for the reply.

Tried that but not sure it works as we need to look over 5 different fields rather than 1?

Hope this makes sense