topic Re: subfield? in QlikView

subfield?

Anonymous — Sat, 14 Nov 2015 03:59:23 GMT

Hi,

I have the a field that is formatted like this example:- 100:780:876:600000

What is the easiest way to have each number in its own field in the expression formula?

Cheers,

Laura

arulsettu — Sat, 14 Nov 2015 04:13:24 GMT

try like this

SubField('100:780:876:600000',':',1) as filed1,

SubField('100:780:876:600000',':',2) as filed2

SubField('100:780:876:600000',':',3) as filed3

SubField('100:780:876:600000',':',4) as filed4

Anonymous — Sat, 14 Nov 2015 04:51:58 GMT

Hi,

the field that I used was just to show an example of the format. their all different

arulsettu — Sat, 14 Nov 2015 04:54:58 GMT

can u post sample and your expecting result

Anonymous — Sat, 14 Nov 2015 05:06:43 GMT

I've used MID:

MID([Tech1Data],8,3)