Set Analysis: syntaxes, examples

[#1]

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

[#2]

Very helpful! Thank you!

[santho_ak]

Precise & helpful. Thanks

[luismadriz]

Great document Fabrice! many thanks

[Anonymous]

Great document. Thank You!

[ysj]

thanks for sharing

[olivieresmieugi]

MERCI!!

[tanda_54043]

Wow this was a great tool for set analysis for a newbie, thanks

[Anonymous]

Excelent!

Thanks a lot.

[benoit_barbier]

Thank You for the document. I see that a french document existing on this link : http://community.qlik.com/docs/DOC-4889 but it doesn't work as all the qlik french community. Does anybody say why there isn't document in french ?

[cristian]

Hello

Does anybody have an ideea why this is working :

sum({<luna={"$(=(month(today())))"},an={"$(=year(today()))"},lit_doc={'B'}>}cant)

and this does not:

sum({<luna={"$(=(month(addmonths(today(),-3))))"},an={"$(=year(today()))"},lit_doc={'B'}>}cant)