topic Re: wildmatch on field multiple value in QlikView

wildmatch on field multiple value

nboccassini — Sat, 16 Nov 2024 00:19:38 GMT

Hi all,

I have two tables:

TABLE_A

Field_1	Field_2
1	920001
2	920002
2	920001
4	...
5	..

TABLE_B

Field_3

920001

920002

....

NOTE: Field_2 is a subset of Field_3 and Table_A and Table_B must be unlinked

I have a pivot with Field_3 and Field_1 in dimension and I want to show only Field_1 that has Field_2 in Field_3 and the Field_1 thas has Field_2 null because the field_1 is valid only for Field_3=Field_2 (when declared)

NOTE2: If it helps I can add in Table_A all possible Field_1

Gab

Re: wildmatch on field multiple value

sunny_talwar — Tue, 14 Jul 2020 11:56:53 GMT

Have you tried doing something like this

Sum(If(Field_3 = Field_2, Measure))

Re: wildmatch on field multiple value

nboccassini — Tue, 14 Jul 2020 12:15:35 GMT

I can't use this solution because I need null and 0 expression, so I can't suppress it.

I need a solution for a calcualted dimension. I tried to use:

aggr(if(WildMatch( Concat(DISTINCT Field_3),'*'&Field_2&'*')>0,Field_1,Null()),Field_1)

but it works only for Field_1 having only one Field_2.

I tried, to concatenate Field_2 value for each Field_1 but I can't use it in wildmatch

Re: wildmatch on field multiple value

sunny_talwar — Tue, 14 Jul 2020 12:45:07 GMT

I am not sure I am able to follow... are you able to share a dummy sample where we can see the issue?

Re: wildmatch on field multiple value

nboccassini — Tue, 14 Jul 2020 13:06:49 GMT

See attached.

ID 12 does not has limitation so it's correct to see in pivot.

ID 1364 ha limitation. It must be visible only on Cod.Business 9200063 and 9200096, so it must not be shown on 9200060.

Gab

Re: wildmatch on field multiple value

nboccassini — Tue, 14 Jul 2020 14:21:58 GMT

@sunny_talwar do you have any idea?

Re: wildmatch on field multiple value

sunny_talwar — Tue, 14 Jul 2020 15:56:04 GMT

This seems to work as a calculated dimension

=If([Cod. Business] = BUS or Len(Trim(BUS)) = 0, ID)