Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
badelma23
Contributor
Contributor

Create a field or list based on multiple variables fields

Hello Community,

I have different calculated fields in different text objects. I would like to have all these values, somehow grouped as a single field, or list variable, or any type of structure that accept the union of different values. That group is needed for a formula that accepts only one field (IRR). Do you have any idea how can i achieve something like this?

Thank you in advance!

Del

1 Reply
psilva001
Creator
Creator

You can create one variable for each text object.

After, you can do your desired operation using only variables

$(vR1)='AAA'

$(vR1)='BBB'

$(vR1)='CCC'


Text box expression:      $(vR1)&'-'&$(vR1)&'-'&$(vR1)


Result:     AAA-BBB-CCC