topic Help Set Analysis in QlikView

Help Set Analysis

ivandrago — Wed, 20 Apr 2011 17:36:37 GMT

Hi,

Could someone explain what the following Set Anlaysis will do?

Thanks

count({$<[Type]={'COMP'}, [Key Event]={'COMP}, [N Flag]={0}, [Cocierge Type]={"*"}-{'ADDE'}>} DISTINCT key])

Help Set Analysis

IAMDV — Wed, 20 Apr 2011 17:44:21 GMT

Counts the distinct Key

where [Type] = 'Comp'

And

[Key Event] = 'Comp'

And

[N Flag] = 0

And

[Cocierge Type] is everything expect 'Addeng'

Help Set Analysis

erichshiino — Wed, 20 Apr 2011 17:45:16 GMT

count({$<[Type]={'COMP'}, [Key Event]={'COMP}, [N Flag]={0}, [Cocierge Type]={"*"}-{'ADDE'}>} DISTINCT key])

it count distinct keys where type = COMP, KEY EVENT = COMP, N FLAG = 0 and COCIERGE TYPE is not ADDE

Help Set Analysis

ivandrago — Wed, 20 Apr 2011 17:45:47 GMT

Was that Except?

Help Set Analysis

disqr_rm — Wed, 20 Apr 2011 17:46:09 GMT

it will give you count of distinct Key values whare Type = "COMP" and Key Event = "COMP" and N Flag = 0 and Concierge Type is everything but "ADDE".

Help Set Analysis

IAMDV — Wed, 20 Apr 2011 17:50:18 GMT

Yes, thats right. It is a set operator. Please read below...

+ : Union Returns the set of all records that belong to
the unioned sets

- : Exclusion Returns records that belong to the first but
not the other of the two set identifiers.

* : Intersection Returns records that belong to both of the
set identifiers.

/ : Symmetric Difference Returns a set that belongs to either, but not
both of the set identifiers.

Help Set Analysis

IAMDV — Wed, 20 Apr 2011 17:54:31 GMT

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/6685.QlikLearn_2D00_Set_2D00_Analysis_2D00_Presentation.pdf:550:0]

Hope this will be useful reference 🙂

Good luck!