Set Analysis: syntaxes, examples

[#1]

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

[#2]

Hi Fabrice,

This is very simple and easy to learn.

Keep up your good work .

[psankepalli]

One of my all time Fav. document. thank you

[perla_chirag]

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!

[Anonymous]

Great!

[nihhalmca]

Useful, thanks.

[#7]

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)

[jkampmeijer]

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

[kamal_sanguri]

Very good document for the beginners to start with set analysis..

[Anil_Babu_Samineni]

Fabric,

If possible, Can you please share me that qvw and Data...

[Anil_Babu_Samineni]

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...