Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think it could be done with rather simple string-operations like:
= subfield(
subfield(
mid(extra, index(extra, answer & '|')),
chr(10) , 1),
'|', 2)
- Marcus
I think it could be done with rather simple string-operations like:
= subfield(
subfield(
mid(extra, index(extra, answer & '|')),
chr(10) , 1),
'|', 2)
- Marcus
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