topic Unable to fetch results with using Aggr in Value list. in QlikView

Unable to fetch results with using Aggr in Value list.

Anonymous — Fri, 05 May 2017 06:10:51 GMT

Hi ,

I have different expressions stored in variables in one valuelist expression I'm fetching data with aggr function but it is giving error if I use it in value list().

num(round($(Variable21)),'##,##,###'),
//(sum(aggr($(vOEE)*$(vWeight),Cell,CellType,PlantCode,PlantName)))
Num($(vOEE)*$(vWeight), '#0 %')

Commented part is fetching wrong results .

There are two dimensions :

1. Value list fetching.

2. =CalendarMonth&'-'&Right(CalendarYear,2)

It was according to report needs, that I had to use value list .

Any inputs are appreciated. Thanks in advance.

Re: Unable to fetch results with using Aggr in Value list.

Anil_Babu_Samineni — Fri, 05 May 2017 06:17:36 GMT

Would you elaborate variable as well vOEE, vWeight ??

May be try this?

(sum(aggr(Num($(vOEE)*$(vWeight),'#0%'),Cell,CellType,PlantCode,PlantName)))

Re: Unable to fetch results with using Aggr in Value list.

Anonymous — Fri, 05 May 2017 06:28:33 GMT

Hi ,

Nope its not working ,

These are basically expressions :

vWeight = ((sum([Cycle Time]))
/sum(TOTAL<CellType>[Cycle Time])
)*100

vOEE=

(($(vAvailability))
*
($(vPerformance))
*
($(vQuality))
)

its variable which contents other variables so it basically four level variables

Re: Unable to fetch results with using Aggr in Value list.

Anil_Babu_Samineni — Fri, 05 May 2017 07:22:23 GMT

Would you able to provide sample, Please?

Re: Unable to fetch results with using Aggr in Value list.

Anonymous — Wed, 10 May 2017 06:10:39 GMT

Hi Anil ,

Thanks for reply .

It has been solved by using pick match instead of Valuelist.

Re: Unable to fetch results with using Aggr in Value list.

Anil_Babu_Samineni — Wed, 10 May 2017 06:17:04 GMT

You mark as Assumes Answer, Try to flag correct answer of your response