2 Replies Latest reply: Sep 13, 2016 12:22 PM by buck master RSS

    Sense: Valuelist function limit

    buck master

      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.