Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
LP27
Creator II
Creator II

Wild Match function in Set Analysis

Hi,

I  am not sure how to use wild match within set Analysis.

Here is my case -

Order NoRemark
1E1;E*,R*
2

E2;E3;E4

3E1;R1,R*
4E4;

Now I want to exclude the R values in column Remark. So it should only show row E2;E3;E4 and E4;

Here is what I have tried :-

Count({$<Remark - = {"*R*"}>} OrderNo)

  1. Note sure if I have to use single or double quotes to search the string ?
  2. Since my Remark Column already contains * with values, will it still be considered doing "*R*" 

Could some one guide me best way to solve this issue.

 

Thanks in advance!!!

1 Solution

Accepted Solutions
nisha_rai
Creator II
Creator II

Hi,

Please use the below condition:

Count(distinct {<Remark-={"*R*"}>}[Order No])WildMatch.PNG

View solution in original post

2 Replies
nisha_rai
Creator II
Creator II

Hi,

Please use the below condition:

Count(distinct {<Remark-={"*R*"}>}[Order No])WildMatch.PNG

View solution in original post

kaushiknsolanki

Hi,

It works in my case.

See the image Below.Capture.JPG

 

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".