topic Re: Max(Aggr()) facing problem in QlikView

Max(Aggr()) facing problem

Fri, 04 Oct 2013 13:30:51 GMT

I am trying to find the max visits value from a trend chart for visits.

I am using the following expression :

=Max(Aggr(Sum({<Date={">=$(PrevMonth_2)<=$(=Date(Max(Date)))"}, Quarter=, [Ref]={'All'}>}Visits)/1000000,Date))

Here, PrevMonth_2 is a variable that points to the six months
prior to the current selected month i.e. start month of the trend.

Ref={‘All’} condition is used so that I get all the visits for ‘all’ the referrals.

Date is the variable that I have named for months.

The above expression returns me only the visits for the latest selected Month (variable Date) i.e. the last data point of the trend.

Kindly help me to resolve it. It is quite urgent.

Thanks

Re: Max(Aggr()) facing problem

Mon, 07 Oct 2013 10:15:35 GMT

Hi,

PFA and modify your sample application expression or post you sample application

Re: Max(Aggr()) facing problem

CELAMBARASAN — Mon, 07 Oct 2013 10:26:54 GMT

You should try something like this

=Max({<Date={">=$(PrevMonth_2)<=$(=Date(Max(Date)))"}, Quarter=, [Ref]={'All'}>} Aggr(Sum({<Date={">=$(PrevMonth_2)<=$(=Date(Max(Date)))"}, Quarter=, [Ref]={'All'}>}Visits)/1000000,Date))

Re: Max(Aggr()) facing problem

Mon, 07 Oct 2013 11:07:59 GMT

Thanks a lot. Its working fine now.

Re: Max(Aggr()) facing problem

Mon, 07 Oct 2013 11:37:03 GMT

Celambarasan Adhimulam Thanks for your solution. Can you please also explain me why the expression that was used by me was not correct?
I have used similar expression in other applicatoins and they are working fine.

Re: Max(Aggr()) facing problem

CELAMBARASAN — Mon, 07 Oct 2013 12:37:59 GMT

Hi,

I don't know what you have done in other applications.

But here your excluding the selections in Sum which is inside aggr.

If you apply simply max function for around the Aggr then it will take the Maximum value for the selection alone.

You have to use the same set analysis outside the Aggr.