Search code examples
qlikviewqliksense

Qlik - Comma Seperated list to Array for Dimension

I have a field that is stored as a string list of changing size. For Example, 

7,5,6,4,2,3

I need to build an expression such that it creates an array which will become the dimension on the x axis for a bar chart

I have used 

SubField(string_list, ',')

However, it produces only 1 value.

Solution

  • You have to use SubField in a LOAD statement, if you want to use it without the field_no parameter and generate a record for each value. Otherwise you would need to specify the field_no explicitly.

    Best regards, Tom