topic Re: set analysis not working in QlikView

set analysis not working

cafcptg2011 — Fri, 09 Jan 2015 19:22:36 GMT

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

p_verkooijen — Fri, 09 Jan 2015 19:46:08 GMT

I think your forgot the = before the aggr.

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

rwunderlich — Fri, 09 Jan 2015 20:40:59 GMT

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 — Mon, 12 Jan 2015 12:17:34 GMT

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

thanks anyway