topic Re: Aggr function including set analysis with same field? in QlikView

Aggr function including set analysis with same field?

Tue, 15 Nov 2011 09:23:33 GMT

Hi guys,

Is it possible when using an aggr function to include one of the fields used in it in the set analysis part?

My aim is to create a trending chart (by ignoring month selected) but do aggregation across this. Currently having no luck.

my expression is as follows:

sum({$<Master_Calendar_MonthYear=>}aggr(Case_Limits,Master_Calendar_MonthYear=))

Any thoughts would be appreciated.

Regards,

Aggr function including set analysis with same field?

Tue, 15 Nov 2011 13:07:06 GMT

Hi,

I am not sure what you want to do, but you can start to use something like this:

aggr(sum({$<Master_Calendar_MonthYear=>}Case_Limits,Master_Calendar_MonthYear=))

Halmar

Aggr function including set analysis with same field?

SunilChauhan — Tue, 15 Nov 2011 13:14:13 GMT

use this

aggr(sum({$<Master_Calendar_MonthYear=>}Case_Limits),Master_Calendar_MonthYear)

Re: Aggr function including set analysis with same field?

Tue, 15 Nov 2011 14:37:18 GMT

Hi,

Thanks for this. However, in the line chart I am creating I still do not get the line (data values) spanning across the months.

eg if I click on September 2011 (Master_Calendar_Month_Year) I want to see a line chart with all the Months Limits represented. And to make it even more confusing my original expression is slightly longer than stated:

sum({$}aggr(Case_Limits,[Case_RPC],Case_Division,Master_Calendar_MonthYear))

This gives me the correct figure but only for the month I am selecting. If I could get this to neglect the calendar selection the user makes it would be perfect.

Thanks again for suggestion.

Re: Aggr function including set analysis with same field?

Tue, 15 Nov 2011 14:45:43 GMT

Correction to expression I am using:

sum({$<Master_Calendar_MonthYear=>}aggr(Case_Limits,[Case_RPC],Case_Division,Master_Calendar_MonthYear))

Re: Aggr function including set analysis with same field?

Tue, 15 Nov 2011 15:13:57 GMT

I managed to get the solution in the end:

Expression as follows:

sum({$<Master_Calendar_MonthYear=>} aggr( sum{$<Master_Calendar_MonthYear=>}Case_Limits), Case_RPC,Case_Division,Master_Calendar_MonthYear ))