topic max function in QlikView

max function

Mon, 02 Feb 2015 10:41:20 GMT

hi guys I am using the max function to return values for the maximum field number but somehow it returns all values

i.e:

Sum( {<Year={'$(vPriorYear)'}, Month={'$(vMaxMonth)'},Day={'<=$(vMaxDay)'},Date_Week_Num={">=$(=Num(Date_Week_Num(MAX(Date_Week_Num))))"}>}Counter_Num)

returns:

for the date of 2014/01/27 to 2014/01/31

Re: max function

alexandros17 — Mon, 02 Feb 2015 10:47:10 GMT

What does this mean?

Date_Week_Num={">=$(=Num(Date_Week_Num(MAX(Date_Week_Num))

I shoul write

Date_Week_Num={">=$(=MAX(Date_Week_Num))

Re: max function

Mon, 02 Feb 2015 11:01:40 GMT

hi Alessandro,

I have put your expression and I think what I am struggling with is to return the data for the Max week number of the prior year.......it gives me the values for the month not for that particular week.