topic Re: Need help in filtering a field in QlikView

Need help in filtering a field

Anonymous — Tue, 14 Apr 2015 11:08:31 GMT

Hi Friends, Need a quick help..

I have column like below,

IP Address

10.10.10.1

10.10.10.2

10.30.40.5

10.55.45.7

172.65.10.11

When I load this column I dont want IP addresses starting with 10.10. and I want IP addresses starts only with 10.. Any suggestions please?

Re: Need help in filtering a field

oknotsen — Tue, 14 Apr 2015 11:10:06 GMT

Try this:

SQL SELECT *

FROM source

WHERE SomeField LIKE '10.*'

AND SomeField NOT LIKE '10.10.*'

;

Re: Need help in filtering a field

fvelascog72 — Tue, 14 Apr 2015 11:14:28 GMT

Something like:

LOAD

INLINE [

10.10.10.1

10.10.10.2

10.30.40.5

10.55.45.7

172.65.10.11

]

Where not([IP] like '10.10*');

Re: Need help in filtering a field

nagarjuna_kotha — Tue, 14 Apr 2015 11:23:44 GMT

HI Vijay,

Kindly find below attached file.

IP_ADD:

LOAD

INLINE [

10.10.10.1

10.10.10.2

10.30.40.5

10.55.45.7

172.65.10.11

]

Where not([IP] like '10.10*');

Regards,

nagarjuna

Re: Need help in filtering a field

Karthik3 — Tue, 14 Apr 2015 11:27:01 GMT

IF(LEFT([IP Address], 5)<>'10.10', IF(LEFT([IP Address], 2)='10', [IP Address])) AS [IP Address]

Re: Need help in filtering a field

Anonymous — Tue, 14 Apr 2015 13:50:08 GMT

Thanks everyone for your timely help.