Set analysis wildcard

[#1]

I have a section of my set analysis as follows;

IPAddress={'10.144*'}

The full expression is;

COUNT(DISTINCT {$<UserName-={'*test*'},TestAccount={'false'},Firm-={'ICAP','*TEST*'},IPAddress={'10.144*'}>}SessionId)

But I am confused as it seems to be including values such as 10.44.121.53, 10.44.132.44 and 10.44.234.45

I don't understand why values without the string 10.144 are being included. Can anyone explain? And what would be the correct expression to ensure only values starting with 10.144 are included and nothing else?

[anbu1984]

Can you post sample qvw

[#3]

The data is sensitive, so i can't really.

Is my logic correct then?

[anbu1984]

Your logic is correct

[maxgro]

I think your expression is correct; you can check with this

=concat(distinct {<IPAddress={"10.144.*"}>} IPAddress, ' ')

[rwunderlich]

What version (SR) are you using?

-Rob

[#7]

11.20.11718.0 SR1 64-bit edition

[#8]

If i explain a little more maybe it will help.

It is when I select a dynamic bookmark with the following query;

-10.144 -10.244

This expression still remains visible in the chart

COUNT(DISTINCT {$<UserName-={'*test*'},TestAccount={'false'},Firm-={'ICAP','*TEST*'},IPAddress={'10.144*','10.244*'}>}SessionId)

[rwunderlich]

There were some search issues corrected in later updates. I suggest you update to a later SR (like SR8) and retest.

-Rob