AGGR() NOT WORKING IN 12 SR1?

[Anonymous]

Hi

I upgraded to Qlikview 12 SR1(Before SR2 was out) a while back. Since then the Aggr () function is not working .. I am using this function in many of my dashboards. Can someone confirm if it is working fine in SR2?

Thanks!

[sunny_talwar]

I have not heard anything related to Aggr() in either SR1 or SR2. What exactly is not working? Can you share an example?

[Anonymous]

I  cannot share the doc but give an example of the function i am using:

sum(aggr(sum({<[Data type]={'Inventory'},[FiscalYear]={$(vFYear)},[FiscalMonth]={$(vFMonth)},[FiscalWeek]={$(vPOSMAXWeekIn)}>}Inventory)

*

if(IsNull([Standard unit price]),

if([Doc Currency Calc]='USD',sum({<[Data type]={'Inventory'},[FiscalYear]={$(vFYear)},[FiscalMonth]={$(vFMonth)},[FiscalWeek]={$(vPOSMAXWeekIn)}>}Cost),

sum({<[Data type]={'Inventory'},[FiscalYear]={$(vFYear)},[FiscalMonth]={$(vFMonth)},[FiscalWeek]={$(vPOSMAXWeekIn)}>}Cost*MatCostExRate)),

sum({<[Data type]={'Inventory'},[FiscalYear]={$(vFYear)},[FiscalMonth]={$(vFMonth)},[FiscalWeek]={$(vPOSMAXWeekIn)}>}[Standard unit price])),[Part number],Distributor))

This was working totally fine before the upgrade. Now it just gives 0!

[rwunderlich]

Is this in a straight table? If so, try debugging this way (or put in a straight table).

1. Remove the label from the expression so the column header will display the entire expression after $() substitutions.

2. Right click the header cell and select copy, cell.

3. Paste this expanded expression text into another expression and see what the Expression Editor has to say about it.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com