topic Re: Error in Expression:Nested Aggregation Not Alowd in Accesspoint in QlikView

Error in Expression:Nested Aggregation Not Alowd in Accesspoint

Wed, 25 Jan 2017 21:41:39 GMT

if ( COMMON_YEAR = year(today()) ,

if(GetSelectedCount(COMMON_DIRECT) = 0 and GetSelectedCount(COMMON_VPDIR) = 0 and GetSelectedCount(COMMON_DIRMGR) = 0 and GetSelectedCount(COMMON_MGR) = 0,

sum (aggr( if( (sum({<Data_Month_Billable=,Data_Month={">= $(=(YearStart(Today()))) <=$(=vClosedMonth)"} ,CATEGORY={"Billable"}>}BLENDED_ACT_ALLOC) > 0 or
sum({<Data_Month_Billable=,Data_Month={">=$(=vNextMonth) <=$(=(YearEnd(Today()))) "},CATEGORY={"Billable"}>}BLENDED_ACT_ALLOC) > 0 or
SUM({<Data_Month_Billable=,CATEGORY={"Billable"}>}if(Data_Month=(vNextMonth),BLENDED_ACTUALS)) > 0 ) and

SUM({<Data_Year={$(=YEAR(TODAY()))},Data_Month_Billable=,CATEGORY={"Billable"},REPORT_UNITS={'Units'}>} TOTAL_BUDGET) = 0, 1),COMMON_DIRECT,PROJECT_ID,OBS_SUBAREA))

,

above expression has been used and its working fine in the desktop version and fine in the dev-access point as well. And deployed to the QA and reloaded. in the access point i am getting

can some body advice me on this issue.

TIA

Pavan

Re: Error in Expression:Nested Aggregation Not Alowd in Accesspoint

sunny_talwar — Wed, 25 Jan 2017 22:03:36 GMT

What is vNextMonth here? Is it a hardcoded value or an expression?

Re: Error in Expression:Nested Aggregation Not Alowd in Accesspoint

Wed, 25 Jan 2017 22:19:54 GMT

vNextMonth is a variable

giving date

Re: Error in Expression:Nested Aggregation Not Alowd in Accesspoint

sunny_talwar — Wed, 25 Jan 2017 22:20:55 GMT

Is this variable an expression? Can you share its definition?

Re: Error in Expression:Nested Aggregation Not Alowd in Accesspoint

Wed, 25 Jan 2017 22:26:30 GMT

Let vNextMonth = Date(AddMonths('$(closedtemp)',1),'M/D/YYYY');

it gives current month as closedtemp is december

Re: Error in Expression:Nested Aggregation Not Alowd in Accesspoint

Wed, 25 Jan 2017 22:28:58 GMT

as it is working fine, gives us the desired result. even its working fine after refreshing in the qmc/accesspoint.

once deployed to the new server(QA) and after refreshing it, its hwoing that error message.

Something to do with SR issue?

Re: Error in Expression:Nested Aggregation Not Alowd in Accesspoint

Thu, 26 Jan 2017 14:25:57 GMT

ok, I got it. QA is having not enough ram and if I select some other filters I could see the chart. nothing wrong with the expression, qa server having issues.

note: the error message for bar chart.

if you convert this chart to straight table then you will see some other message I believe?

anyhow, some times I will not understand the error handling/warning msgs in QV .

thanks guys. any more inputs would be appreciable.