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

# Set Analysis: syntaxes, examples

cancel
Showing results for
Did you mean:
Not applicable

## Set Analysis: syntaxes, examples

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

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

Tags (4)
Labels (3)

• ### New to QlikView

MVP

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

Employee

Congrats, very useful

Partner - Contributor III

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

Partner - Specialist II

good work..

Partner - Contributor III

Very useful thank you!

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

Not applicable

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

Happy new year

MVP

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

Merci beaucoup

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