topic Re: how this expression works? in QlikView

how this expression works?

Fri, 10 Oct 2014 12:39:43 GMT

Load *, if(index(Code, ' '), subfield(Code, ' '), if(index(Code, '-'), subfield(Code, '-'), Code)) as Test

PrashantSangle — Fri, 10 Oct 2014 12:47:01 GMT

Hi,

index(Code, ' '), subfield(Code, ' ')

Index() returns position of space if it returns true i.e. position value more than 0

then perform Subfield ()

Subfield() gives data of Code before space

for example

if code = abc cde

then index(Code,' ') return 4

then Subfield(Code,' ') Operation Performs which return abc

if code = abc-cde

then second condition i.e. if(index(Code, '-'), subfield(Code, '-') perform

if code = abcde

then final else i.e. return all string

Regards

Fri, 10 Oct 2014 12:51:19 GMT

Hi expert,

as well as i have araised one more question expr2 please explain me that also