Introduction to Set Analysis (video) - Part 1

[Michael_Tarallo]

This video gets right to the point and shows you how to get started with Set Analysis. There are various blogs and articles on this topic that go in deeper, but I suggest you start here first.

Also consider this post by hic‌ Natural Sets

Next Video: Set Analysis - Part 2 - Cool Stuff You Can Do (video)

[#2]

Simple and clear,

Thank you Michael,

FMa

[simon_minifie]

Wonderfully clear and helpful.

Thank you.

[#4]

Hi..

Michael

I want some of videos .

Wonderfully clear

Thank you.

[#5]

Hi..

Michael

I have saw  set analysis videos good ,

Thank you so much .

I want some real time scenario in Data Modal and Tables .

Please Help Me.

Thanks,

Sreenu

[josephinetedesc]

Exactly what I needed - asked the question today about how to do this.  Thank you

[josephinetedesc]

Hi All

I have another question:

I also have a file but unsure how to load it. !

So the idea is that I want an overview but at the same time, a user should be able to click on the filters they  want the and the numbers of cars sold will show the result of the filter operations as well as show the total sold. 

Jo

Month	CarMake	NumSold	Dealer	chassy
1/01/2015	Fords	1	Dealer1	01
1/01/2015	Holdens	2	Dealer2	02
1/01/2015	Holdens	3	Dealer3	03
1/02/2015	Fords	2	Dealer1	04
2/02/2015	Holdens	2	Dealer2	05
3/02/2015	Holdens	2	Dealer3	06
4/03/2015	Fords	1	Dealer1	07
5/03/2015	Holdens	2	Dealer2	08
6/03/2015	Holdens	3	Dealer3	09
1/02/2015	Holdens	2	Dealer1	10
2/02/2015	Fords	2	Dealer2	11
3/02/2015	Holdens	2	Dealer3	12
1/03/2015	Fords	1	Dealer1	13
1/03/2015	Holdens	1	Dealer2	14
1/03/2015	Holdens	1	Dealer3	15
1/03/2015	Fords	2	Dealer1	16
1/04/2015	Holdens	2	Dealer2	17
1/04/2015	Holdens	2	Dealer3	18
1/04/2015	Fords	1	Dealer1	19
1/04/2015	Holdens	2	Dealer2	20
1/05/2015	Holdens	3	Dealer3	21
1/05/2015	Kias	2	Dealer1	22
1/05/2015	Fords	2	Dealer2	23
1/05/2015	Holdens	2	Dealer3	24
1/01/2015	Fords	1	Dealer1	25
1/01/2015	Holdens	2	Dealer2	26
1/01/2015	Kias	3	Dealer3	27
1/01/2015	Fords	2	Dealer1	28
1/01/2015	Holdens	2	Dealer2	29
1/02/2015	Kias	2	Dealer3	30
2/02/2015	Fords	1	Dealer1	31
3/02/2015	Holdens	2	Dealer2	32
4/03/2015	Kias	3	Dealer3	33
5/03/2015	Kias	2	Dealer1	34
6/03/2015	Fords	2	Dealer2	35
1/02/2015	Holdens	2	Dealer3	36
2/02/2015	Fords	1	Dealer1	37
3/02/2015	Holdens	1	Dealer2	38
1/01/2015	Kias	1	Dealer3	39
1/01/2015	Fords	2	Dealer1	40
1/01/2015	Holdens	2	Dealer2	41
1/02/2015	Kias	2	Dealer3	42
2/02/2015	Fords	1	Dealer1	43
3/02/2015	Holdens	2	Dealer2	44
4/03/2015	Kias	3	Dealer3	45
5/03/2015	Kias	2	Dealer1	46
6/03/2015	Fords	2	Dealer2	47
1/02/2015	Holdens	2	Dealer3	48
2/02/2015	Kias	2	Dealer1	49
3/02/2015	Fords	2	Dealer2	50
1/01/2014	Fords	1	Dealer1	51
1/01/2014	Holdens	2	Dealer2	52
1/01/2014	Kias	3	Dealer3	53
1/01/2014	Fords	2	Dealer1	54
2/02/2014	Holdens	2	Dealer2	55
2/02/2014	Kias	2	Dealer3	56
2/02/2014	Fords	1	Dealer1	57
2/02/2014	Holdens	2	Dealer2	58
6/03/2014	Kias	3	Dealer3	59
6/03/2014	Kias	2	Dealer1	60
6/03/2014	Fords	2	Dealer2	61
6/03/2014	Holdens	2	Dealer3	62
6/03/2014	Fords	1	Dealer1	63
6/03/2014	Holdens	1	Dealer2	64
2/02/2014	Kias	1	Dealer3	65
2/02/2014	Fords	2	Dealer1	66
2/02/2014	Holdens	2	Dealer2	67
2/02/2014	Kias	2	Dealer3	68
2/02/2014	Fords	1	Dealer1	69
2/02/2014	Holdens	2	Dealer2	70
1/05/2014	Kias	3	Dealer3	71
1/05/2014	Kias	2	Dealer1	72
1/05/2014	Fords	2	Dealer2	73
1/05/2014	Holdens	2	Dealer3	74
1/05/2014	Fords	1	Dealer1	75
1/05/2014	Holdens	2	Dealer2	76
1/05/2014	Kias	3	Dealer3	77
4/01/2014	Fords	2	Dealer1	78
4/01/2014	Holdens	2	Dealer2	79
4/01/2014	Kias	2	Dealer3	80
4/01/2014	Fords	1	Dealer1	81
4/01/2014	Holdens	2	Dealer2	82
4/01/2014	Kias	3	Dealer3	83
4/01/2014	Kias	2	Dealer1	84
4/01/2014	Fords	2	Dealer2	85
1/02/2014	Holdens	2	Dealer3	86
1/02/2014	Fords	1	Dealer1	87
1/02/2014	Holdens	1	Dealer2	88
1/02/2014	Kias	1	Dealer3	89
1/02/2014	Fords	2	Dealer1	90
1/02/2014	Holdens	2	Dealer2	91
1/02/2014	Kias	2	Dealer3	92
1/02/2014	Fords	1	Dealer1	93
1/02/2014	Holdens	2	Dealer2	94
1/02/2014	Kias	3	Dealer3	95
1/02/2014	Kias	2	Dealer1	96
1/02/2014	Fords	2	Dealer2	97
1/04/2014	Holdens	2	Dealer3	98
1/04/2014	Kias	2	Dealer1	99
1/04/2014	Fords	2	Dealer2	100

[Anonymous]

Hi Josephine,

I thinn that you could solve your problem creating two expressions.

The first one will show the number of cars sold with the current selection, and the second one will show always the total, any selecction will affect this result.

Expression 1:

= sum({$}NumSold)

Expression 2:

=sum({1}Numsold)

I hope it could help you.

If you want to attach a file you have to use the advanced options in the comment, but I really don't find it in this post. Maeby you can open a new Question and attach here the link.

[Michael_Tarallo]

Hi Josephine - I appreciate your interest and commend your progress with Qlik Sense! For your reference, may I suggest you open your discussion threads here: New to Qlik Sense - that way ALL community members will see it and have a chance to help. When you post / reply to a comment in a document, only those that follow or have commented will be notified of your comment, vs. the entire community seeing your post. This way your ensured to get a reply, in most cases.

Regards,

Mike T

Qlik

[josephinetedesc]

Thank you this worked beautifully.

I am sorry I cannot do the correct sign - I just cannot see where to do it.

so the 1 means - use all data - ignore selections

=sum(Numsold)

the $ means - use the selections

= sum({$}NumSold)

Thank you again.

Jo

[josephinetedesc]

Thanks Michael

I thought something was different, but I did not know what it was.

What should I do now?

Jo