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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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?