# QlikView Documents

Documents for QlikView related information.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER

# Set Analysis: syntaxes, examples

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

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

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

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

Partner

good work..

Partner

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
Revision #:
1 of 1
Last update:
‎2013-09-26 04:24 AM
Updated by: