If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Has anyone created a field with an array of values?
Below is script that demonstrates what I'm trying to achieve.
The desired output is for [Inner Table] to have the following:
[Data_Table]:load * inline [Code, Value1, A 1, B1, C2, D2, E2, F3, G 3, H 3, I ];
For Each x in FieldValueList('Code') Let vCurrentCode = $(x); [Outer Table]: LOAD '$(x)' as "Outer Code" AutoGenerate 1; For Each y in FieldValueList('Code') Let ConcatenatedValue = ConcatenatedValue & ' ' & Peek('Value',y,'Data_Table') & ',';
[Inner Table]: LOAD '$(x)' as "Inner Code", '$(ConcatenatedValue)' AS "Inner Value" AutoGenerate 1 Where $(x) = $(vCurrentCode); Let content = Null; Next y Next x
SubField would work if I was going the other way.
max dreamer solved it in a QlikView discussion.
For anyone reading this later and wondering what the solution was, you can find it here:
Create array from field values
View solution in original post
Try SubField() like this
SubField(InnerValue, ',') AS Value
Yes, I read it wrongly, you can do this by using Group by & Concat().