Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ali_hijazi
Honored Contributor

parsing columns

Hello

got a table as shown in the attached excel file

there is a column called extra: it contains the possible options for a drop down list

can Qlik parse this via a wizard or I need to use string functions to get the required data?

for example in the attached excel, the first line corresponds to Domain data family and the answer is 6 and 6 corresponds to Financial Transaction

the possible values are saved in the column named extra

1 Solution

Accepted Solutions

Re: parsing columns

I think it could be done with rather simple string-operations like:

= subfield(

     subfield(

       mid(extra, index(extra, answer & '|')),

     chr(10) , 1),

    '|', 2)

- Marcus

2 Replies

Re: parsing columns

I think it could be done with rather simple string-operations like:

= subfield(

     subfield(

       mid(extra, index(extra, answer & '|')),

     chr(10) , 1),

    '|', 2)

- Marcus

ali_hijazi
Honored Contributor

Re: parsing columns

you know I was looking for the n value in chr(n)

in qlik sense values appear on one line, when I export values to excel every line displays on new line so the delimiter turned out to be chr(10)

and this solved my issue

I will mark your answer as correct to close the discussion

Community Browser