Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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
Highlighted

How is your full expression looks like?

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)
Highlighted
MVP
MVP

Highlighted
Creator III
Creator III

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)