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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
louise119
Creator III
Creator III

Qlik Function for array of strings

Is there a function that stores an array of strings?

1 Solution

Accepted Solutions
Vegar
MVP
MVP

Rob is right,  your measure need an concat(UKRegion, ',') in order to display all values. Depending on your data you might even need to use concat(DISTINCT UKRegion, ',')  to ensure that each UKRegion is displayed only once.

 

Your current expression, =UKRegion, is equivalent to  =only(UKRegion) and will only display values if you have only one single UKRegion in your selection.

View solution in original post

6 Replies
sidhiq91
Specialist II
Specialist II

@louise119  Could you please provide some example on what you are exactly looking?

 

Vegar
MVP
MVP

There is no explicit array functionality in Qlik Sense, but hopefully that won't stop you in what you are trying to accomplish.

Could you please explain your situation?

louise119
Creator III
Creator III
Author

Thank you.

I attached for example.
 I use dimension for the right side  and use measure for the left side.
I can't see the data when I use measures.

 

test.png

louise119
Creator III
Creator III
Author

Thank you.

I attached for example.
 I use dimension for the right side  and use measure for the left side.
I can't see the data when I use measures.

test.png

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

To display the multiple string values in a Measure, you would use the Concat function. 

=Concat(UKRegion, ',')

-Rob

Vegar
MVP
MVP

Rob is right,  your measure need an concat(UKRegion, ',') in order to display all values. Depending on your data you might even need to use concat(DISTINCT UKRegion, ',')  to ensure that each UKRegion is displayed only once.

 

Your current expression, =UKRegion, is equivalent to  =only(UKRegion) and will only display values if you have only one single UKRegion in your selection.