Aggr giving error with partial sum in Qlikview

[Anonymous]

Hi All,

I need to display YTD but as per clients requirements I had to make few changes in given chart. As YTD i'm unable to display given partial sum for OEE %.

Please have a look and let me know if any possible solution .

Open to any other suggestions for displaying YTD.

Attach given file . Please look in  Summary and Summary% tab.

[Anil_Babu_Samineni]

Definitely, We can help you. Can you help us to find out the issue? Seems OEE% YTD works to me

[Kushal_Chawda]

Would you be able to give actual final expression without variable? And in which chart you are getting wrong results? what is expected result?

[Anonymous]

Nope check it is showing addition of given percentages.. What I need is just like you can see in Capacity utilization.

Ans is 46.44%

You can put this expression in OEE5 and Check :

//Num((RangeAvg(Before(sum(Aggr(($(vOEE)*$(vWeight))/100, FMonth,CellType,Cell,List2)),0,RowNo(TOTAL)))), '#0.## %') 

I need this value in YTD not under max month.

[Anonymous]

Hi Kushal,

Actually its 5 level variable used previously so I decided not to disturb that. and

I'm getting wrong on Summary and Summary% sheets with charts named as summary/sumaary% using value list.

In OEE% YTD I'm getting 92.87 what we need is 46.44 .

[Kushal_Chawda · Accepted solution]

try below formula

Num((if(SecondaryDimensionality()=1,(sum(Aggr(($(vOEE)*$(vWeight))/100, FMonth,CellType,Cell,List2))),

sum(Aggr(($(vOEE)*$(vWeight))/100,FMonth,CellType,Cell,List2))/Count(DISTINCT CalendarYear&CalendarMonth))), '#0.## %')

[Anonymous]

Thanks a lot .It worked.

[Kushal_Chawda]

np