Discussion board where members can get started with Qlik Sense.
I have an Application field that has either one or more than one Application name. I use a replace to get ride of any spaces. The App names are separated by a comma. My code is as follows:
if(isNull(Application),'NIL', if(Application like '*,*',
Replace(Subfield("Application",','),' ', ''), Replace(Application, ' ', '')))
The problem is with a value like "App A, App B - XXX, App C - XXX"
The desired result would be like so:
However I am getting only AppA
Any ideas on how I can achieve this splitting?
Update: Am able to split the Application names correctly, it is when linked with another table that only the first Application name appears in the straight table.
load subfield(trim(test),',') as test;
can you share your mock source data?
also u can try like this (it should work if your application value within double quote)
load *, SubField(Application,',') as Application_Revised;
load * Inline [
he has to eliminate spaces in his string before using subfield;
load subfield(trim(Application),',') as Application;
Using mock data both fields is correct
if(Application like '*,*',
Subfield(Replace(Application, ' ', ''), ','),
Application) as App,
subfield(trim(Application),',') as test,
Application as testApplication,
Subfield(Application, ',') as testSF;
Load * inline [
Am thinking when linked with my report table, somehow only the first App name is kept...
subfield(replace(value,' ',''),',') as result
1,'App A, App B - XXX, App C - XXX'