Set of RUT'S

[pgalvezt]

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!

[Sokkorn]

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

[Gysbert_Wassenaar · Accepted solution]

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.