Extracting 'Treatment' to create a new column.

[Fatima_Augen]

Hi All,

I have a column that includes 'treatment,' and I'm trying to extract the 'treatment' from that column to create a new one. I'm new to Qlik Sense and attempted to create new dimensions using this formula.

"if(Match(AdSetName, '001-*'), SubField(SubField(AdSetName, '-', 2), '-', 1), SubField(AdSetName, '-', 1))"

This is the column format

Ad Set Name

Circumcision-Hyderabad

Piles-Hyderabad-Sep23

001-Circumcision-Vizag-Urology-LG

Lipoma-Trivandrum-Sep23

Piles-Kochi-Sep23

001-Circumcision-Kochi-Urology-LG

Piles-Chennai-Sep23

001-Piles-Vizag-Procto-LG

Lipoma-Coimbatore-Sep23

Gynecomastia-Bangalore-Sep23

Gynecomastia-Bangalore-Sep23

Piles-Vizag-Sep23

If any helps that is really appreciate

Thanks,

Fatima

[Lauri · Accepted solution]

I think you are close to solving this. Try this:

if(WildMatch(AdSetName, '001-*'), SubField(AdSetName, '-', 2), SubField(AdSetName, '-', 1))

[Fatima_Augen]

Thank you !!! it worked.