Discussion Board for collaboration related to QlikView App Development.
Anyone can suggest to me how to transform the list of variable values from excel into the table.
I have defined 2 columns, the variable name(Variable) & variable values(VarExpression).
My initial intention was to load the variable into QlikView , then match the list of values during the where clause.
But I failed, this is because some values are in the number & text format.
The result will look like below:
Any suggestion is highly appreciated.
Try SubField function
SubField(VarExpression, ',') as VarExpression;
LOAD * INLINE [
View solution in original post
Your suggestion is very useful, Thank you very much!