topic Re: Aggr Function in Set Analysis in QlikView

Aggr Function in Set Analysis

stjernvd — Thu, 18 Jun 2015 10:56:24 GMT

Hi,

To return sale of highest sold product for previous year I found this expression:

=Max({<Year={$(=Max(Year)-1)}>} aggr (sum( {<Year={$(=Max(Year)-1)}>} Sale),Company_Name,Product))

Why does does Max have to have {<Year={$(=Max(Year)-1)}>} after it, and not just Max(aggr(sum and then the rest?

thanks

Re: Aggr Function in Set Analysis

Thu, 18 Jun 2015 11:12:10 GMT

Hi,

The above expression is used to get max sales last year.

Re: Aggr Function in Set Analysis

stjernvd — Thu, 18 Jun 2015 11:22:06 GMT

Hi Amardip,

Thank you.

I am just wondering why the function isn't:

Max(aggr (sum( {<Year={$(=Max(Year)-1)}>} Sale),Company_Name,Product))

instead of

=Max({<Year={$(=Max(Year)-1)}>} aggr (sum( {<Year={$(=Max(Year)-1)}>} Sale),Company_Name,Product))

Do they both mean the same thing? Why is Max(year) used twice?

Re: Aggr Function in Set Analysis

sunny_talwar — Thu, 18 Jun 2015 11:27:17 GMT

Have you tried using both the expressions? Do they give you the same results, if they do then in your case it won't matter, but there are times (hard to give an example) where it does make sense to use a set expression in the outermost function also. Ultimately it all depends on the requirement.

Best,

Sunny

Re: Aggr Function in Set Analysis

Kushal_Chawda — Thu, 18 Jun 2015 11:37:52 GMT

As per your statement "sale of highest sold product for previous year" you can do something like attached here