Discussion Board for collaboration related to QlikView App Development.
from a field value like "80-100%" i want to extract the first % value (80) and save it in a field and also the 2nd % value (100) and save it in another field.
How can this be done ?
Subfield(Yourfield, '-', 1) as Field1,
PurgeChar(Subfield(YourField, '-', 2), '%') as Field2
I hope, you can use the function SubField(Field1,'-') for first value to be stored and TextBetween(Field1, '-','%') for second value to be stored in variable.