topic Re: Sense: Valuelist function limit in App Development

Sense: Valuelist function limit

deerhunter — Mon, 12 Sep 2016 21:36:17 GMT

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

sunny_talwar — Mon, 12 Sep 2016 23:48:11 GMT

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

deerhunter — Tue, 13 Sep 2016 16:22:54 GMT

You are the man, Thank you