Discussion board where members can get started with QlikView.
i have 2 field values
i want to extract the string 'qtr' from both values. how to achieve that?
Go to Solution.
This will work for
View solution in original post
It's 3rd subfield (delimited by '_') from end.
=SubField(YourField,'_', - 3 )
the end is not specific....after 2017 there can be values like 2017_abc etc..
I don't think this solution will work because we can't predict that qtr will be in same position. So it is not flexible with different data right?
replace(PurgeChar ( Replace('sales_mrtyf_qtr_09_2017','_qtr_','$'),
= Mid(TextFieldnamehere, Index(YourTextFieldnamehere, 'qtr'), 3)
yes you are right.....the wildmatch solution given above is working fine.....