Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
maybe this:
Count( {< Serialnummer ={"BF*","BM*"} >} Serialnummer )
I hope it can helps.
maybe this:
Count( {< Serialnummer ={"BF*","BM*"} >} Serialnummer )
I hope it can helps.
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.