Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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.

View solution in original post

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)