topic Re: How to get values correct in field in QlikView

How to get values correct in field

Mon, 21 Oct 2013 12:32:26 GMT

Hi,

I Have address field and if there is no value in county means I have to show blank value but instead my straight table is showing postcode instead of county can anyone help me how to do this.

Address,

subfield(Address, ',' , 1) as Address1,

subfield(Address, ',' , 2) as Address2,

subfield(Address, ',' , 3) as Address3,

subfield(Address, ',' , 4) as Town,

subfield(Address, ',' , 5) as County,

subfield(Address, ',' , 6) as Postcode

Re: How to get values correct in field

Mon, 21 Oct 2013 12:48:27 GMT

Any help please

Re: How to get values correct in field

rustyfishbones — Mon, 21 Oct 2013 12:50:45 GMT

Hi,

If PostCode is the last part of the Address you could try

SUBFIELD(Address,',', -1) AS PostCode

Re: How to get values correct in field

Mon, 21 Oct 2013 12:55:16 GMT

Thanks and if I want to get the same for other fields also i,e if the data presents in the field then it shouid take value, otherwise it should show blank is it possible?

Re: How to get values correct in field

rustyfishbones — Mon, 21 Oct 2013 13:00:36 GMT

It depends on how the Address is set up at source

if each part of the Address is seperated by a comma you should get a blank value when it's blank

Re: How to get values correct in field

Mon, 21 Oct 2013 13:03:33 GMT

Yes the Adress is separated by comma like for eg:

3 Nora Street , , UK, NE34 0RA

is it possible to get correct please help as I am not getting idea.

Re: Re: How to get values correct in field

jagannalla — Mon, 21 Oct 2013 13:03:42 GMT

Hi,

Try this,

LOAD *,

If(Country='',Null(),subfield(Address, ',' , 1)) as Address1,

If(Country='',Null(),subfield(Address, ',' , 2)) as Address2,

If(Country='',Null(),subfield(Address, ',' , 3)) as Address3;

LOAD * INLINE [

    Country, Address

    India, "SD,47,MNCL"

    ,"SD1,471,MNCL1"

];

Hope it helps you....

Cheers!!

Jagan

Re: Re: How to get values correct in field

rustyfishbones — Mon, 21 Oct 2013 13:10:43 GMT

Here is a file showing that it works when I add some text objects

HTH

Re: Re: How to get values correct in field

jagannalla — Mon, 21 Oct 2013 13:20:51 GMT

Sorry for the misunderstanding...

Re: How to get values correct in field

Mon, 21 Oct 2013 13:24:08 GMT

Thanks and it's working.