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, thanks!!!

[#3]

Great document and easy to understand

[#4]

It is helpful!

-TDP

[johnpaul]

Excellent overview of Set Analysis - I have been using Set Analysis for years and I still learn't something new.

Great work Fabrice!

[#6]

One year later, and it's still very helpful. Thank you Fabrice !

Un an après, c'est toujours très utile. Merci Fabrice !

[#7]

Thanks Fabrice its very nice, but I have not seen using date variable on left hand side in the set expression. The below expression is not working for me.

Sum({< Var1 = {">=$(=Date(StartDt,'M/D/YYYY')<=$(=Date(EndDt,'M/D/YYYY')"} >} Amt)

Variable Var1 is =Date(Floor(Validdate))

Cant' use date variable on left hand side?

[mattphillip]

Hi Fabrice,

Excellent guide thank you. I have a question though, I'm trying to generate a list using two double expressions and I'm wondering how it would be structured in a set analysis (see below for example):

Criteria (Table dimensions ' Student, Qualification, Year, Programme):

(Qualification = "HNC" AND Year = "2") OR (Qualification = "HND" AND Year = "3")

I noted in your guide that you can have multiple criteria, but that these are considered together as a single statement (e.g. Qualification = "HNC", "HND" AND Year = "2", "3"). This would catch the wrong data however e.g. students with an HNC entering at year 3 and students with an HND entering at year 2 (Qualification = "HNC" and Year = "3", Qualification = "HND" and Year = "2".). Is it possible to consider these two statements individually to create a single list/chart?

Any help would be much appreciated.

Matt

[Anonymous]

Amigos

Como conseguir a versão em portugueis???

Poderiam me ajudar

[lucianosv]

Quando vc instala o QV em português, ele trás no help como análise de conjuntos.

Enviado do meu iPhone

Em 16/12/2014, às 11:16, LUCIANA SILVEIRA <qcwebmaster@qlikview.com> escreveu:

Qlik Community

Set Analysis: syntaxes, examples

novo comentário de LUCIANA SILVEIRA Visualize todos os comentários sobre este documento

Amigos

Como conseguir a versão em portugueis???

Poderiam me ajudar

Responda a este e-mail para responder ao comentário de LUCIANA SILVEIRA.

Seguindo LUCIANA SILVEIRA nestes fluxos: Fluxo de conexões

[#11]

Very helpful. Thanks for sharing.