help with Subfield

Anonymous — Fri, 22 Feb 2013 20:59:40 GMT

I have a product field that I would like to break out the subparts for use in a drill down. All the data is in one column.

QT110M

QT110M_1

QT110M_2

QT110M_3

I tried using the below script to parse them out. Which works ok. But the Part Name Sub field only give me the Number.

Upper(subfield(PROD_SPEC_FLD7,'_',1)) as Part_Name,
Upper(subfield(PROD_SPEC_FLD7,'_',2)) as Part_Name_Sub

What I would like to be able to do is seperate them out but still have the full name. Because I drill down its nots real intuitive what 1, 2 and 3 equal.

How can parse out the feild names with an underscore and then still capture the whole name.

Thank you for any help you can provide.

Cassadi

Re: help with Subfield

m_woolf — Fri, 22 Feb 2013 21:09:54 GMT

Add:

PROD_SPEC_FLD7 as Part_Name_All;

Re: help with Subfield

Anonymous — Sat, 23 Feb 2013 00:15:37 GMT

I dont think that will quite work. I want to pull out the feilds with the _1, _2 as a another field but I want to see the whole feild as QT110M_1 and QT110M_2 not as just 1 and 2.

topic Re: help with Subfield in QlikView

help with Subfield

Re: help with Subfield

Re: help with Subfield