Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For those that find this document in a search - you may also want to check out these videos to learn Set Analysis:
A Beginners' Introduction to Set Analysis
About the attached document:
The doc is organized by question:
- to select all or just known members
- to select through search strings, variables that can store just members but also the whole set
- to select using two fields, a boolean test, a function like concat(), sum(), p() or e(), rank()
In this updated version, I have added some few sections and some examples.
It is a translation of a french doc I have written few weeks ago: http://community.qlik.com/docs/DOC-4889
Thank you. This is very helpful.
Thank you for excellent document Aunez!
At the beginning of 4th chapter you're stating that double quotes are used for text:
"({*} for numeric, {"*"} for text)"
Correct me if I'm wrong, but I think double quotes are used for search expressions while single quotes are used for text.
Lukasz
Lukasz,
For text Field, if you want all values, you may use nothing like <Client=>, no quote like {*}, simple quotes like {'*'} or double quotes like{"*"}. For numeric, you do not use any quotes.
See excellent post by Henric about simple or double quotes : http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/09/quoteology
That is effectively search string. A single star will search everything that has letters. That is why the difference between <Client=> and <Client={"*"}> resides in the NULL that is selected in the first sentence and not in the second one. If you do not have any NULL in your field, there is no difference.
Fabrice
Me ha ayudado mucho.( Nice doc)
Thanks a lot from Spain
Excellente Fabrice! Un bon résumé!
Merci beaucoup!
Hi Fabrice,
This is very simple and easy to learn.
Keep up your good work .
It's very useful for me. Thanks!
Very impressive! The best and most complete in depth explanation of set analysis I've ever seen. Thank you!
Very Useful. and well explained concepts of set analysis.
Thanks
A really nice document Fabrice, many thanks for taking the time and putting it together for the Community.