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

sum of Distinct count

How do I get overlap ?

if(rowno()=0,

sum( Aggr(count( Distinct Measure),Dimension))- Count (DISTINCT Measure), Count (DISTINCT Measure))

For example in below screenshot

Overlap = 33-13= 20

Capture.PNG

3 Replies
Highlighted
Champion III
Champion III

Try this?

if(Dimensionality() = 0,

sum( Aggr(count( Distinct Measure),Dimension))- Count (DISTINCT Measure), Count (DISTINCT Measure))

Highlighted
Creator III
Creator III

Dimensionality()=0 or rowno()=0 =>one or the other will give same.

"sum( Aggr(count( Distinct Measure),Dimension))- Count (DISTINCT Measure)" this is what not working!

Highlighted
Champion III
Champion III

So what is that you are seeing there? No value? Can you share some sample data to work on?