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

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
vishsaggi
Champion III
Champion III

Try this?

if(Dimensionality() = 0,

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

Anonymous
Not applicable
Author

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!

vishsaggi
Champion III
Champion III

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