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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

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