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
MayilVahanan

Hi

Its nice document to learn about set analysis.

Not applicable

All,

Thanks for your nice comments. As someone told me for the french version, it is more a tutorial than "just" a doc.  However, to complete it and make a true tutorial, I will add a part of exercices/solutions.

Fabrice

0 Likes
Clever_Anjos
Employee
Employee

Congrats, very useful

lucpechali
Partner - Contributor III
Partner - Contributor III

Hello, could I have it in french ? And if you added parts of exercices, it will be nice...

0 Likes
shree909
Partner - Specialist II
Partner - Specialist II

Its really  helpful..

good work.. 

0 Likes
cn_sa_dev
Partner - Contributor III
Partner - Contributor III

Very useful thank you!

0 Likes
Not applicable

Luc,

You can find the french version at the follwing address:

http://community.qlik.com/docs/DOC-4889

The two versions are very similar. I did not do the exercices yet.

Fabrice

Not applicable

hi AUNEZ,

my expression is not work,the variable gives errors, I don't know how to do next.

my expression is:=sum( {<year={$(=max(year)-1)},$(V_test)={"daynumberofyear(today())"}>} ACT_SALES_AMOUNT);and the variable expression is:=DayNumberOfYear(DATE_KEY).

thanks.

Chenlinlin

0 Likes
Not applicable

Useful Document for learning.... Thank You Mr Aunez

Happy new year

0 Likes
maxgro
MVP
MVP

Congratulations Fabrice, the most interesting and comprehensive guide on "set analysis" that I have seen

Merci beaucoup

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