topic sum of Distinct count in QlikView

sum of Distinct count

Anonymous — Thu, 20 Jul 2017 19:47:24 GMT

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

vishsaggi — Thu, 20 Jul 2017 20:24:01 GMT

Try this?

if(Dimensionality() = 0,

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

Anonymous — Thu, 20 Jul 2017 20:59:00 GMT

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 — Thu, 20 Jul 2017 21:01:19 GMT

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