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: 
cafcptg2011
Creator
Creator

set analysis not working

Hi,

i have the following expression in pivot table

this part of expression works nice : aggr( max(List), Article)

but complete expression doesn't work:

=min( { < List = {$(aggr( max(List), Article))} > } value1)

am I doing anything wrong? can anyone help me please on this?

thanks in advance,

CAFC

1 Solution

Accepted Solutions
cafcptg2011
Creator
Creator
Author

the solution for my pb is simply...max(value1)...

thanks anyway

View solution in original post

3 Replies
p_verkooijen
Partner - Specialist II
Partner - Specialist II

I think your forgot the = before the aggr.

=min( { < List = {$(=aggr( max(List), Article))} > } value1)

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I think Paul is correct about the "=" but the expression also does not seem logical to me.

aggr( max(List), Article)


returns a set of max(List) values. Which value should be used as the List = modifier. All of them?

-Rob

cafcptg2011
Creator
Creator
Author

the solution for my pb is simply...max(value1)...

thanks anyway