Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
deerhunter
Creator
Creator

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.

2 Replies
sunny_talwar

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))


deerhunter
Creator
Creator
Author

You are the man, Thank you