Discussion Board for collaboration related to QlikView App Development.
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
try below script
load * inline [
Concat(Value,' ,') as InnerValue
Group By Code;
Drop table [Data_Value];
View solution in original post
May be try this..
LOAD Code,Concat(Value,',') as Inner_Value Resident [Data_Table] Group by Code;
DROP Table [Data_Table];
That solved it.
may be helpful for you?
values from field to array by macro
Using Array to Identify Modified Rows in Qlikview Table | Smart ERP Solutions