Help Set Analysis

[ivandrago]

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])

[IAMDV · Accepted solution]

Counts the distinct Key

where [Type] = 'Comp'

And

[Key Event] = 'Comp'

And

[N Flag] = 0

And

[Cocierge Type] is everything expect 'Addeng'

[erichshiino]

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

[ivandrago]

Was that Except?

[disqr_rm]

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".

[IAMDV]

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.

[IAMDV]

[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!