Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.