Qlik Community

QlikView Documents

Documents for QlikView related information.

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

Comments

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
Employee

Congrats, very useful

lucpechali
New Contributor II

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

shree909
Valued Contributor II

Its really  helpful..

good work.. 

cn_sa_dev
New 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
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:
‎09-26-2013 04:24 AM
Updated by: