Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

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: