Discussion Board for collaboration related to QlikView App Development.
Hi i have a field with the values in the below format
I have to separate it into 3 columns like
Go to Solution.
Try like below,
SubField(FieldName,'-',1) as [Column 1],
SubField(FieldName,'-',2) as [Column 2],
SubField(FieldName,'-',3) as [Column 3]
Subfield(Field,'-',1) as Column1,
Subfield(Field,'-',2) as Column2,
Subfield(Field,'-',3) as Column3
If you want to split it as only 3 columns then use
subfield(FieldName,'-',n) as new_filed_name