2 Replies Latest reply: Sep 13, 2016 12:22 PM by Buck Master

# Sense: Valuelist function limit

Any help on solving this challenge, I'm building a valuelist of 18 calculations and trying to calculate amounts for each value in the list within a table object. It looks like the max list of fields is at 10. Any idea how one would do a work-around?

If you can send a sample qvf App that would be great... Thanks in advance

Dimension:

ValueList('Field1','Field2','Field3','Field4','Field5','Field6','Field7','Field8','Field9', 'Field10','Field11','Field12','Field13','Field14','Field15','Field16','Field17','Field18')

Measure:

if(ValueList('Field1','Field2','Field3','Field4','Field5','Field6','Field7','Field8','Field9', 'Field10','Field11','Field12','Field13','Field14','Field15','Field16','Field17','Field18')='Field1,

sum(Field1),

if(ValueList('Field1','Field2','Field3','Field4','Field5','Field6','Field7','Field8','Field9', 'Field10','Field11','Field12','Field13','Field14','Field15','Field16','Field17','Field18')='Field2,

sum(Field2),

if(ValueList('Field1','Field2','Field3','Field4','Field5','Field6','Field7','Field8','Field9', 'Field10','Field11','Field12','Field13','Field14','Field15','Field16','Field17','Field18')='Field3,

sum(Field3),

.

.

.

if(ValueList('Field1','Field2','Field3','Field4','Field5','Field6','Field7','Field8','Field9', 'Field10','Field11','Field12','Field13','Field14','Field15','Field16','Field17','Field18')='Field18,

sum(Field18)

))))))  --> whatever the correct number of closing brackets are.

• ###### Re: Sense: Valuelist function limit

May be use Pick(Match(...)) instead of using the if statement

Pick(Match(

ValueList('Field1','Field2','Field3','Field4','Field5','Field6','Field7','Field8','Field9', 'Field10','Field11','Field12','Field13','Field14','Field15','Field16','Field17','Field18'),

'Field1','Field2','Field3','Field4','Field5','Field6','Field7','Field8','Field9', 'Field10','Field11','Field12','Field13','Field14','Field15','Field16','Field17','Field18'),

Sum(Field1),

Sum(Field2),

Sum(Field3),

Sum(Field4),

Sum(Field5),

Sum(Field6),

.

.

.

Sum(Field18))

• ###### Re: Sense: Valuelist function limit

You are the man, Thank you