topic Re: Max Field in script in QlikView

Max Field in script

fkeuroglian — Mon, 19 Jan 2015 14:07:45 GMT

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

Mon, 19 Jan 2015 14:10:36 GMT

try this

firstsortedvalue(Hnua08Cta ,-Hnua07Pre)

fkeuroglian — Mon, 19 Jan 2015 14:22:49 GMT

Manoj, Invalid Expression said

Mon, 19 Jan 2015 14:26:57 GMT

try this now

firstsortedvalue(Hnua07Pre,-Hnua08Cta )

fkeuroglian — Mon, 19 Jan 2015 14:30:50 GMT

Invalid

then i have to put some group by?

Mon, 19 Jan 2015 14:31:45 GMT

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

give me some sample records

fkeuroglian — Mon, 19 Jan 2015 14:33:39 GMT

Both of them are number(integer)

i attached the qvd and the qvw

thank you!

anbu1984 — Mon, 19 Jan 2015 15:46:55 GMT

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