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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
ericdelaqua
Creator
Creator

RangeSum variables

I need help getting the sum of a range of variables.

I have 100s of the variables in the following format $(text1),$(text2),$(text3),$(text4),$(text5),$(text6),$(text7),$(text8)

I would like to get the following sums hopefully without having to list all of them. Is there a way to rangesum this variables?

$(text4)+$(text5)+$(text6)

$(text2)+$(text3)

$(text1)+$(text2)+$(text3)+$(text4)+$(text5)+$(text6)+$(text7)+$(text8)

 

Thank you

1 Reply
marcus_sommer

AFAIK it's not possible. If it wouldn't be variables else fields there would be possibilities to query the available fields within loops to fetch the relevant information and to concat them with new variables. But in regard of saving time it would be probably faster just to write the whole stuff instead of developing the above mentioned possibility.

Beside this I suggest to rethink your whole approach because your data look like a crosstable and within the most scenarios it's more suitable to transform them to categorize, filter and aggregate the data.

- Marcus