Max Field in script

[fkeuroglian]

Hi expert,

i have  2 fields, Hnua08Cta and Hnua07Pre, for each Hnua08Cta could be more than 1 values, i want to only bring the max Hnua07Pre value

is this posible to do this in the script?

using firstsortvalue() or max function?

i attached a qvw and a qvd to see this example

thank you a lot

Fernando

[#2]

try this

firstsortedvalue(Hnua08Cta ,-Hnua07Pre)

[fkeuroglian]

Manoj, Invalid Expression said

[#4]

try this now

firstsortedvalue(Hnua07Pre,-Hnua08Cta )

[fkeuroglian]

Invalid

then i have to put some group by?

[#6]

may i know what kind of data u have in the fields

give me some sample records

[fkeuroglian]

Both of them are number(integer)

i attached the qvd and the qvw

thank you!

[anbu1984 · Accepted solution]

LOAD HnuA07Cta,

     Max(HnuA07PRe),

     FirstSortedValue(HnuA07PRe,-HnuA07PRe )

FROM

[HNUA07.qvd]

(qvd) Group by HnuA07Cta;

FirstSortedValue may not work for few rows since you have duplicates in Hnua07Pre