Set Analysis: syntaxes, examples

Report Inappropriate Content

For those that find this document in a search - you may also want to check out these videos to learn 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

Report Inappropriate Content · ‎2015-02-20

Nice doc. I'm having a problem with my Set Analysis. I'm trying to count all fields in a table where the contents = <?> here is my code

sum({<[$Fields]={'<?>'}>} 1)

Can some one point me in the right direction.

Thanks

Report Inappropriate Content · ‎2015-02-25

Thanks so much for this. Extremely helpful!

rajkumarb · ‎2015-03-23

Very Helpful, Thank You for Sharing

Report Inappropriate Content · ‎2015-03-27

Very useful document

mithilesh17 · ‎2015-04-03

very useful..thanks for sharing it with community!

jkampmeijer · ‎2015-04-09

Very helpfull, especialy the variables and Greater than mixtures.

Report Inappropriate Content · ‎2015-04-13

Thank you very much, very useful doc.

jkampmeijer · ‎2015-06-08

Your answer is shown in the video: A Beginners' Introduction to Set Analysis (see link at the top)

This example is shown in the video:

Sum({$<Year={2015},Country={"Germany"}>}Sales)

ogster1974 · ‎2015-10-20

This is my starter for ten on any set analysis queries I have.

markodonovan · ‎2015-11-08

For a simple video on Set analysis , check out this video:

Thanks

Mark

techstuffy.tv