topic Re: Re: Set analysis wildcard in QlikView

Set analysis wildcard

Mon, 22 Sep 2014 14:24:31 GMT

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?

Re: Set analysis wildcard

anbu1984 — Mon, 22 Sep 2014 14:27:40 GMT

Can you post sample qvw

Re: Set analysis wildcard

Mon, 22 Sep 2014 14:42:07 GMT

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

Is my logic correct then?

Re: Re: Set analysis wildcard

anbu1984 — Mon, 22 Sep 2014 16:10:26 GMT

Your logic is correct

Re: Set analysis wildcard

maxgro — Mon, 22 Sep 2014 23:41:45 GMT

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

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

Re: Set analysis wildcard

rwunderlich — Tue, 23 Sep 2014 02:43:30 GMT

What version (SR) are you using?

-Rob

Re: Set analysis wildcard

Tue, 23 Sep 2014 07:20:16 GMT

11.20.11718.0 SR1 64-bit edition

Re: Re: Set analysis wildcard

Tue, 23 Sep 2014 08:52:22 GMT

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)

Re: Set analysis wildcard

rwunderlich — Wed, 24 Sep 2014 03:08:45 GMT

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

-Rob