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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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

Labels (1)
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
PaulVerkooijen_DataFix
Partner - Specialist II
Partner - Specialist II

I think your forgot the = before the aggr.

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

rwunderlich
MVP
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