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
Hi Fabrice,
This is very simple and easy to learn.
Keep up your good work .
One of my all time Fav. document. thank you
Thanks a lot for this doc Fabrice!
Its right up there on my Bookmarks bar for me to refer to it every time I have a question about Set Analysis!
Great!
Useful, thanks.
Why does this not work? If i add multiple named fields only the first is considered.
Product_Type__c-={'LearningSpace Enterprise', 'LearningSpace Pro', 'Replay', 'Replay One', 'METIVision', 'N/A', 'LearningSpace One', 'LearningSpace', 'UltraPortable Replay', 'Replay Connect + Replay One', 'LearningSpace Go', 'LearningSpace One VHA', 'Meti-FX', 'LS Connect + LS One'}>}Status)
use -= match or -= mixmatch
match( str, expr1 [ , expr2,...exprN ] )
The match function performs a case sensitive comparison.
Example:
match( M, 'Jan','Feb','Mar')
returns 2 if M = Feb
returns 0 if M = Apr or jan
mixmatch( str, expr1 [ , expr2,...exprN ] )
The mixmatch function performs a case insensitive comparison.
Example:
mixmatch( M, 'Jan','Feb','Mar')
returns 1 if M = jan
Very good document for the beginners to start with set analysis..
Fabric,
If possible, Can you please share me that qvw and Data...
I am planning to do this, if you have any Daw data with Excel - can you please share me that Raw data file. It's really very useful practice...