Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Alternative states with intersection and unon

Two Month filters with alternate states set1,set2

selection:

set1-June2017

set2-May2017

Count({set1*set2} ID) is not giving me intersection

count({set2-set1}D) is not giving me CIN's only present in SET2

individual sets are giving me correct counts. Not sure where it is going wrong?

3 Replies
Anil_Babu_Samineni

How is your full expression looks like?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Kushal_Chawda

Anonymous
Not applicable
Author

It is nothing that complex I am using.

Two period filters with alternative states and want to find Intersection and left only, right only Records.

It works fine for

set1 : Count({set1}ID)

set2: Count({set2}ID)

Not working for either of below:

Intersection is not working for

Count({set1*set2}ID)

Left only

Count({set1-set2}ID)