Skip to main content
Announcements
Document boards are being consolidated, this board no longer allows NEW documents READ MORE

Set Analysis: syntaxes, examples

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis: syntaxes, examples

Attachments

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

Comments
Not applicable

Hi Fabrice,

This is very simple and easy to learn.

Keep up your good work .

0 Likes
psankepalli
Partner - Creator III
Partner - Creator III

One of my all time Fav. document. thank you

0 Likes
perla_chirag
Contributor III
Contributor III

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!

0 Likes
Anonymous
Not applicable

Great!

0 Likes
nihhalmca
Specialist II
Specialist II

Useful, thanks.

0 Likes
Not applicable

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)

0 Likes
jkampmeijer
Contributor II
Contributor II

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

0 Likes
kamal_sanguri
Specialist
Specialist

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

0 Likes
Anil_Babu_Samineni

Fabric,

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

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

0 Likes
Version history
Last update:
‎2013-09-26 04:24 AM
Updated by: