Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

max function

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

2 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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))

Not applicable
Author

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.