Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
pablomind
Creator
Creator

SUM a series of Fields

Hi everybody,

I have a tough a question. I have an excel table with a series of columns in sequence that match with the values of a field(Codigo_aplicable)...

pablomind_0-1603358706425.png

pablomind_1-1603358827644.png

So what I need is to find a way to sum every column(field) and match it with its proper match in Codigo_aplicable Field. An important detail is this has to be dynamic cause the number of columns(fields) will increase with time so I dont have a fix number.

So what I had been trying to do is this:

AGGR(SUM($(=Codigo_aplicable)),Codigo_control)

But this only works when I select a value in the Codigo_aplicable field. I need it to get its proper match in a Table Chart.

Any help?

Thanks,

Pablo

 

 

Labels (3)
1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

I suggest to consider a transforming of your data-source before trying to calculate and to match their content in any way. To see what is meant take a look here: The-Crosstable-Load.

- Marcus

View solution in original post

2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

I suggest to consider a transforming of your data-source before trying to calculate and to match their content in any way. To see what is meant take a look here: The-Crosstable-Load.

- Marcus

pablomind
Creator
Creator
Author

Thank you very much!