Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
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: