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: 
prayner
Contributor III
Contributor III

Set expression: return all values in field using modifier: {1<....>} without set analysis

I am trying to return all values in field country_name regardless of any selections I have made in other fields:

{1}country_name

Yet this returns nothing. I assume this only works if I use set analysis such as: count({1}country_name).

How can I return all the values in the field without performing set analysis?

The exact set expression I am performing is: findoneof(product_name, {1<country_name={'$(CountrySelected)'}>}product_name)

My only solution is to concat all field values in a variable and pass the variable in the set expression, but this seems inefficient.

Labels (1)
2 Replies
tresesco
MVP
MVP

@prayner , what exactly are you trying to achieve? Why do you think concat({1} ...) won't work?

prayner
Contributor III
Contributor III
Author

It does work, but I am wondering if there is a more simple solution?