Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a function that stores an array of strings?
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.
@louise119 Could you please provide some example on what you are exactly looking?
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?
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.
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.
To display the multiple string values in a Measure, you would use the Concat function.
=Concat(UKRegion, ',')
-Rob
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.