topic Re: Subfield in the QV script in QlikView

Subfield in the QV script

Fri, 22 Jan 2016 10:07:36 GMT

Folks,

Why we use sub field in the script ? how does it work in the real world ? what is the syntax for this ? could you please provide few examples?

Anyone can please throw some light on this..

Kind regards,

Verendra.

PradeepReddy — Fri, 22 Jan 2016 11:11:47 GMT

Subfield() is used to get the some part of the String Data..

Syntax: subfield(s, 'delimiter' [ , index ] )

S - input String

Delimiter : on which Character basis you are trying to get the some part of the string.

Index : After dividing the input string into parts based on Delimiter, which part you required.

Ex:

Let S=abc@def@gh

subfield(S, '@' ,1) returns 'abc'

subfield(S, '@' ,2) returns 'def'

subfield(S, '@' ) returns 'abc'

Fri, 22 Jan 2016 11:54:36 GMT

Thanks a lot Pradeep.

Best regards,

Verendra.