topic selectio in QlikView

selectio

Tue, 24 Nov 2015 11:28:10 GMT

please help me out

Re: subfield

Anonymous — Tue, 24 Nov 2015 11:31:58 GMT

try this at script level into your table:

Load *,

mid(FieldName,4,5) as Year

from Tablename

where mid(FieldName,4,5)>13;

Hope this will help!!

Re: subfield

sunny_talwar — Tue, 24 Nov 2015 11:33:29 GMT

May be this:

SubField([INCIDENT REF], '/', -1) as yourNewFieldName

s1:

LOAD SubField([INCIDENT REF], '/', 1) & '/' & SubField([INCIDENT REF], '/', 2) as [INCIDENT REF],

[Adjuster Name],

[Claim Number],

[Claim Status],

[Net Paid],

[Remaining Reserve],

[Total Experience]

FROM

[AV08Exclude.xls]

(biff, embedded labels, table is Sheet1$);

s1:

LOAD SubField([INCIDENT REF], '/', 1) & '/' & SubField([INCIDENT REF], '/', 2) as [INCIDENT REF],

[Adjuster Name],

[Claim Number],

[Claim Status],

[Net Paid],

[Remaining Reserve],

[Total Experience]

FROM

[AV08Exclude.xls]

(biff, embedded labels, table is Sheet1$)

Where Match(SubField([INCIDENT REF], '/', 2), '14', '15');

Re: subfield

Anonymous — Tue, 24 Nov 2015 11:34:14 GMT

you can also replace mid() with subfield() like:

subfield(FieldName,'/',2) as Year

Re: subfield

mohammadkhatimi — Tue, 24 Nov 2015 11:36:31 GMT

Try this..

SubField([INCIDENT REF],'/',2) as NewField

Hope this will helps u..

Regards,

Mohammad

Re: subfield

avinashelite — Tue, 24 Nov 2015 11:46:47 GMT

try like this :

LOAD *

where SubField([Field_name],'/',2)>13

from

tablename;