Discussion Board for collaboration related to QlikView App Development.
i have below field with different types..like MB,GB & TB in string format.. need to calculate in GB only(only numeric no need of type)..
You can calculate like
If(Right(Space,2) = 'TB', Space / 1024 , Space) as Space
Try like this
if(subfiled(Space,'' ,2))='TB',subfiled(Space,'' ,1))*1024,subfiled(Space,'' ,1))) as Space
GB = PurgeChar(Space,'BMGT')*Pick(Match(Keepchar(Space,'MGT'),'M','G','T'), 1/1024,1,1024)