Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

RangeMax does not work

Hi all,

I would like to know why RangeMax is not working for me. The 2 below boxes are displaying

+ left: GetFieldSelectedCount (ProdCalendar.Year) <-- it displays correctly according to my selection

+ right : RangeMax of the value in the left box (see formular) but it shows nothing. Why ?

Capture.JPG.jpg

Thank you

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Simply write

Max(ProdCalendar.Year)

Or use

=RangeMax($(=GetFieldSelections(ProdCalendar.Year)))

View solution in original post

3 Replies
MK_QSL
MVP
MVP

Simply write

Max(ProdCalendar.Year)

Or use

=RangeMax($(=GetFieldSelections(ProdCalendar.Year)))

Not applicable
Author

So true Max(ProdCalendar.Year) works wonderfully, why should we bother to get the "selected values" then 🙂

Not applicable
Author

By curiosity, why there's a need to add $ to get the RangeMax working ?