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

Using Aggr(...), expressions, and max

Hello, I am trying to use Aggr(....) and I'm having problems. This is how I understand it works.

Max(
  { < Date = {"=Aggr(Date, @5)"} > }
   @5
)

This code will make a table out of Date and @5 and find the max value of @5. The thing is, I need @5 to be an expression. How can I extract the max of the second column in my table created by Aggr? It doesn't seem to work with just the expression in the place of all the @5's, should that work?

3 Replies
Jason_Michaelides
Partner - Master II
Partner - Master II

Erm...I don't inderstand!  What do you want your finished chart to show, exactly?  Please give an example expression.

Not applicable
Author

It's just for a variable. So I just need the one value.

Jason_Michaelides
Partner - Master II
Partner - Master II

Help me out here...please provide some specific examples and if possible some sample data.  Makes helping you a lot easier...