topic Re: Bookmark wildcard selection, not specific values in QlikView

Bookmark wildcard selection, not specific values

Fri, 19 Sep 2014 09:44:47 GMT

I have an IPAddress field and would like to bookmark the ranges;

10.144.* and 10.244.*

If I bookmark the current selection, it remembers the exact IPAddress values selected and not the ranges.

How can I get round this?

Re: Bookmark wildcard selection, not specific values

sundarakumar — Fri, 19 Sep 2014 11:50:22 GMT

u could use the same format in a list box like 10.144.* and press enter this will select all the values that are in this range, then u can add bookmark which will ahve all the selected value.

-sundar

Re: Bookmark wildcard selection, not specific values

Fri, 19 Sep 2014 12:14:32 GMT

Thanks. But how would that work with two ranges at the same time?

Re: Bookmark wildcard selection, not specific values

sundarakumar — Fri, 19 Sep 2014 12:23:49 GMT

I dont think it is straight away possible

in search box type 10.144.* and press enter it will select all the associated 10.144 and again search for 10.244* but this time hold control and press enter.. this will select both..

-Sundar

Re: Bookmark wildcard selection, not specific values

tresB — Fri, 19 Sep 2014 12:25:43 GMT

You can simply type in both with AND like:

Re: Bookmark wildcard selection, not specific values

Fri, 19 Sep 2014 12:29:26 GMT

10.144* AND 10.244*

that doesn't seem to work

Re: Bookmark wildcard selection, not specific values

Fri, 19 Sep 2014 12:37:31 GMT

My recommendation here is to think about this in a slightly different way. Store (or convert) the IP address as a long Integer and search using a function encapsulation of an IP address Range...

We store all our IP addresses in the underlying database as integers using a single function. Then you can do all the usual filtering, sorting etc using the integer value.

Here is our SQL function

Re: Bookmark wildcard selection, not specific values

jonathandienst — Fri, 19 Sep 2014 12:39:51 GMT

I think its an OR selection rather than an AND. You can type this in the list box:

(10.144.*|10.244.*)

HTH

Jonathan

Re: Bookmark wildcard selection, not specific values

tresB — Fri, 19 Sep 2014 12:41:21 GMT

try without wild card

Re: Bookmark wildcard selection, not specific values

jonathandienst — Fri, 19 Sep 2014 12:42:19 GMT

If you bookmark after entering this filter, the bookmark will contain the filter as entered and will dynamically filter based on the wildcards:

Re: Bookmark wildcard selection, not specific values

Fri, 19 Sep 2014 12:44:11 GMT

Re: Bookmark wildcard selection, not specific values

Fri, 19 Sep 2014 13:04:46 GMT

Perfect!

Re: Bookmark wildcard selection, not specific values

Fri, 19 Sep 2014 13:10:34 GMT

And what would I type for the excluded values for the same range

I tried this, but it didn't work

-10.144 AND -10.244

Re: Bookmark wildcard selection, not specific values

Fri, 19 Sep 2014 13:12:38 GMT

And what would I type for the excluded values for the same range

I tried both these, but neither worked

-(10.144.*|10.244.*)

(-10.144.*|-10.244.*)