

- Move Document
- Delete Document and Replies
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Introduction to Set Analysis (video) - Part 1
Mar 3, 2015 5:40:23 PM
Mar 3, 2015 5:40:23 PM
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)

- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Simple and clear,
Thank you Michael,
FMa


- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Wonderfully clear and helpful.
Thank you.

- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Hi..
Michael
I want some of videos .
Wonderfully clear
Thank you.

- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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


- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Exactly what I needed - asked the question today about how to do this. Thank you


- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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 |

- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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.


- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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


- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
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


- Move Comment
- Delete Comment
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Report Inappropriate Content
Thanks Michael
I thought something was different, but I did not know what it was.
What should I do now?
Jo