Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
phirangi91
Contributor III
Contributor III

Unable to fetch results with using Aggr in Value list.

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.  

1 Solution

Accepted Solutions
phirangi91
Contributor III
Contributor III
Author

Hi Anil ,

Thanks for reply .

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

View solution in original post

5 Replies
Anil_Babu_Samineni

Would you elaborate variable as well vOEE, vWeight ??

May be try this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
phirangi91
Contributor III
Contributor III
Author

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

Anil_Babu_Samineni

Would you able to provide sample, Please?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
phirangi91
Contributor III
Contributor III
Author

Hi Anil ,

Thanks for reply .

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

Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)