Qlik Community

Qlik Sense Enterprise Documents

Documents for Qlik Sense related information.

Introduction to Set Analysis (video) - Part 1

Employee
Employee

Introduction to Set Analysis (video) - Part 1

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 hicNatural Sets

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

Tags (1)
Comments
Not applicable

Simple and clear,

Thank you Michael,

FMa

simon_minifie
Contributor III

Wonderfully clear and helpful.

Thank you.

Not applicable

Hi..

Michael

I want some of videos .

Wonderfully clear

Thank you.

Not applicable

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
Contributor III

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

josephinetedesc
Contributor III

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

Capture.PNG

    

MonthCarMakeNumSoldDealerchassy
1/01/2015Fords1Dealer101
1/01/2015Holdens2Dealer202
1/01/2015Holdens3Dealer303
1/02/2015Fords2Dealer104
2/02/2015Holdens2Dealer205
3/02/2015Holdens2Dealer306
4/03/2015Fords1Dealer107
5/03/2015Holdens2Dealer208
6/03/2015Holdens3Dealer309
1/02/2015Holdens2Dealer110
2/02/2015Fords2Dealer211
3/02/2015Holdens2Dealer312
1/03/2015Fords1Dealer113
1/03/2015Holdens1Dealer214
1/03/2015Holdens1Dealer315
1/03/2015Fords2Dealer116
1/04/2015Holdens2Dealer217
1/04/2015Holdens2Dealer318
1/04/2015Fords1Dealer119
1/04/2015Holdens2Dealer220
1/05/2015Holdens3Dealer321
1/05/2015Kias2Dealer122
1/05/2015Fords2Dealer223
1/05/2015Holdens2Dealer324
1/01/2015Fords1Dealer125
1/01/2015Holdens2Dealer226
1/01/2015Kias3Dealer327
1/01/2015Fords2Dealer128
1/01/2015Holdens2Dealer229
1/02/2015Kias2Dealer330
2/02/2015Fords1Dealer131
3/02/2015Holdens2Dealer232
4/03/2015Kias3Dealer333
5/03/2015Kias2Dealer134
6/03/2015Fords2Dealer235
1/02/2015Holdens2Dealer336
2/02/2015Fords1Dealer137
3/02/2015Holdens1Dealer238
1/01/2015Kias1Dealer339
1/01/2015Fords2Dealer140
1/01/2015Holdens2Dealer241
1/02/2015Kias2Dealer342
2/02/2015Fords1Dealer143
3/02/2015Holdens2Dealer244
4/03/2015Kias3Dealer345
5/03/2015Kias2Dealer146
6/03/2015Fords2Dealer247
1/02/2015Holdens2Dealer348
2/02/2015Kias2Dealer149
3/02/2015Fords2Dealer250
1/01/2014Fords1Dealer151
1/01/2014Holdens2Dealer252
1/01/2014Kias3Dealer353
1/01/2014Fords2Dealer154
2/02/2014Holdens2Dealer255
2/02/2014Kias2Dealer356
2/02/2014Fords1Dealer157
2/02/2014Holdens2Dealer258
6/03/2014Kias3Dealer359
6/03/2014Kias2Dealer160
6/03/2014Fords2Dealer261
6/03/2014Holdens2Dealer362
6/03/2014Fords1Dealer163
6/03/2014Holdens1Dealer264
2/02/2014Kias1Dealer365
2/02/2014Fords2Dealer166
2/02/2014Holdens2Dealer267
2/02/2014Kias2Dealer368
2/02/2014Fords1Dealer169
2/02/2014Holdens2Dealer270
1/05/2014Kias3Dealer371
1/05/2014Kias2Dealer172
1/05/2014Fords2Dealer273
1/05/2014Holdens2Dealer374
1/05/2014Fords1Dealer175
1/05/2014Holdens2Dealer276
1/05/2014Kias3Dealer377
4/01/2014Fords2Dealer178
4/01/2014Holdens2Dealer279
4/01/2014Kias2Dealer380
4/01/2014Fords1Dealer181
4/01/2014Holdens2Dealer282
4/01/2014Kias3Dealer383
4/01/2014Kias2Dealer184
4/01/2014Fords2Dealer285
1/02/2014Holdens2Dealer386
1/02/2014Fords1Dealer187
1/02/2014Holdens1Dealer288
1/02/2014Kias1Dealer389
1/02/2014Fords2Dealer190
1/02/2014Holdens2Dealer291
1/02/2014Kias2Dealer392
1/02/2014Fords1Dealer193
1/02/2014Holdens2Dealer294
1/02/2014Kias3Dealer395
1/02/2014Kias2Dealer196
1/02/2014Fords2Dealer297
1/04/2014Holdens2Dealer398
1/04/2014Kias2Dealer199
1/04/2014Fords2Dealer2100
maria_berrocal
Contributor II

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.

Employee
Employee

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
Contributor III

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
Contributor III

Thanks Michael

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

What should I do now?

Jo

Version history
Revision #:
1 of 1
Last update:
‎03-03-2015 05:40 PM
Updated by:
Employee