Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
praveenavelagap
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
Anil_Babu_Samineni

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

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