topic Re: How to group the Ip addresses in QlikView

How to group the Ip addresses

Wed, 19 Oct 2016 11:15:02 GMT

HI all

how to group the Ip addresses with the same numbers upto 3 octets

like 192.168.1.1

192.168.1.2

192.168.2.1

192.168.2.3

192.169..1

192.169.3.3

from the above values in a column , I would like to display a list box with the values like

192.168.1

192.168.2

Thanks

lakshmikandh — Wed, 19 Oct 2016 11:22:33 GMT

You can use mid with index

mid(IPfield,0, index(IPfield,'. ', 2) + 1)

sunny_talwar — Wed, 19 Oct 2016 11:42:50 GMT

I think more like this:

Mid('192.168.1.1', 1, Index('192.168.1.1', '.', 3) - 1)

Mid(IPAddress, 1, Index(IPAddress, '.', 3)-1) as GroupedID