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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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
MVP
MVP

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

I hope it can helps.

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it

View solution in original post

2 Replies
agigliotti
MVP
MVP

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

I hope it can helps.

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
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.