Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nboccassini
Partner - Creator
Partner - Creator

wildmatch on field multiple value

Hi all,

I have two tables:

TABLE_A

Field_1Field_2
1920001
2920002
2920001
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

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

This seems to work as a calculated dimension

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

image.png 

View solution in original post

6 Replies
sunny_talwar

Have you tried doing something like this

Sum(If(Field_3 = Field_2, Measure))
nboccassini
Partner - Creator
Partner - Creator
Author

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

sunny_talwar

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

nboccassini
Partner - Creator
Partner - Creator
Author

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

nboccassini
Partner - Creator
Partner - Creator
Author

@sunny_talwar do you have any idea?

sunny_talwar

This seems to work as a calculated dimension

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

image.png