Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Applicable88
Creator III
Creator III

Wildmatch and Set Analysis

Hello, 

i hope anyone can help here.

Instead of using a wildmatch function I wanted to try if I get the same result with a set analysis expression.

I saw that a colleague had following function. 

1.Count(IF(WildMatch(Serialnumber,'BF*','BM*'),Serialnumber))
As I'm still not very familiar with qlik, my first thinking is that the function counts every Number in the column expression "serialnumber" which starts with BF......or BM....

Somehow I think I missed something about that wildmatch function. 

Otherwise I would get the same results with that one: 

2. Count({<Serialnumber={'BF*','BM*'}>}Serialnummer)

I hope you guys can help explaining me.

Thank you very much in advance. 

 

1 Solution

Accepted Solutions
agigliotti
Partner - Champion
Partner - Champion

maybe this:
Count( {< Serialnummer ={"BF*","BM*"} >} Serialnummer )

I hope it can helps.

View solution in original post

2 Replies
agigliotti
Partner - Champion
Partner - Champion

maybe this:
Count( {< Serialnummer ={"BF*","BM*"} >} Serialnummer )

I hope it can helps.

Applicable88
Creator III
Creator III
Author

Oh,  I got the same values now. I put the double quotation marks now. 

So now I have another two questions: 

1.Why other functions like "if" and "wildmatch" only need a single quotation mark and the set analysis needs the double quotation marks?

2.So it is basically the same function? Can you tell me more about the difference then? 

Thanks.