topic Re: FirstSortedValue inside Set Analysis for an Expression in QlikView

FirstSortedValue inside Set Analysis for an Expression

Wed, 13 May 2015 16:47:02 GMT

I only want to avg the number of cat_favor_points for my favorite cat, which is determined by who has the most cat_favor_points. I cannot seem to get this expression to resolve.

avg({<cat={"='$(=FirstSortedValue(cat,cat_favor_points))'"}>} cat_favor_points)

The FirstSortedValue does work in a text box on its own: ='$(=FirstSortedValue(cat,cat_favor_points))'

Re: FirstSortedValue inside Set Analysis for an Expression

sunny_talwar — Wed, 13 May 2015 17:06:32 GMT

Try this:

=Avg({<cat={"$(=FirstSortedValue(cat,cat_favor_points))"}>} cat_favor_points)

Re: FirstSortedValue inside Set Analysis for an Expression

Wed, 13 May 2015 17:19:13 GMT

awesome that worked thank you! always get a little confused on the semantics

Re: FirstSortedValue inside Set Analysis for an Expression

sunny_talwar — Wed, 13 May 2015 17:20:31 GMT

They indeed are very confusing and drives me crazy sometimes.

Best,

Sunny