Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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