Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers.
I would like to get in the total line of the graphic attached 5 products (and not 7)
I tried Aggr stuff but it removes some lines ( i need to keep all the 4 rows displayed)
i also tried "sum( distinct [Nb product] ) " but it make distinct on customer 23 and 50.
any ideas ?
thanx
May be this
=If(Dimensionality() = 0, Sum(Aggr(Sum(DISTINCT [nb product]), customer)), Sum([nb product]))
May be this
=If(Dimensionality() = 0, Sum(Aggr(Sum(DISTINCT [nb product]), customer)), Sum([nb product]))
whaoo , thanks Sunny.
What is Dimensionality ? works very fine !!
Look here