topic Re: Set of RUT'S in QlikView

Set of RUT'S

pgalvezt — Sat, 25 May 2013 00:10:16 GMT

Hello, Im going to try to explain what I want:

I have a Table like this:

Table1:

Load

Rut as RutCliente,

Nombre as NombreCliente,

Segmento as SegmentoCliente,

Ingreso

From

Qvd Table;

I have a lot of RUT's of Clients like 1000000000 of registers.

So, What I want is do a Filter and bring sum(Ingreso) for that set of selections for example 12.556.334-5,12.556.334-6,12.556.334-5,12.556.334-9

12.556.334-1,12.556.334-3,12.556.334-5. What I not want is to do clic for any rut. I would like to write a set of rut separates for (,) do Enter and QlikView Will select those register.

If you have any doubt please just let me know

Thanks!

Re: Set of RUT'S

Sokkorn — Sat, 25 May 2013 02:22:55 GMT

Hi pgalvezt,

I suggest you to create one variable, let say

vSearchString='('& Concat(DISTINCT If(WildMatch([RutCliente],'12.556.334-*'),'"'&[RutCliente] & '"'),'|')&')'

Create a button with action "Select in Field"

- Field: [RutCliente]

- Search String: =vSearchString

Above solution may not what you looking for, but at least it can be an idea to solve your issus.

Regards,

Sokkorn

Re: Set of RUT'S

Gysbert_Wassenaar — Sat, 25 May 2013 06:09:33 GMT

Here's an example from rebeccad that does the same kind of thing. A user can enter a list of values separated by (semi)comma's and apply those as selection.