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: 
1600eads
Contributor III
Contributor III

aggr() function displays the aggr dimension as the selection value

I have an expression

=aggr(max(date([max_date], 'MM/DD/YYY')),name)

The main issue is, when I bring this expression as a filter, the filter name will show 'name' under the selection bar. It looks to display the dimension the expression was aggregated on. Is there a way to display max_date instead of name when using this aggr expression on the front end? 

Thank you.

Labels (1)
5 Replies
brunobertels
Master
Master

hi try 

firstsortedvalue(max_date , aggr(max(date([max_date], 'MM/DD/YYY')),name))

qv_testing
Specialist II
Specialist II

Try this script level

LOAD Name,

          Max(Date) as Date

Resident TableName

Group By Name;

1600eads
Contributor III
Contributor III
Author

Thanks for the feedback! I was able to achieve this relatively easily by doing a right(max_date, 10) in the format of 'MM/dd/YYYY' and saving that as a master dimension.

The resident load would've been fine as well but that would've caused some extra load to time for our user base which I wanted to avoid. 

vinieme12
Champion III
Champion III

It can't be hidden, this is is because selections are applied on aggregated dimensions

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Chanty4u
MVP
MVP

Try this

=aggr(max(date([max_date], 'MM/DD/YYYY')) as MaxDate, name)