Help with expression

[Anonymous]

Hi,

Could you help me with an expression:

Count(Min(aggr(Sum(N_Month), MYear, Client))>Variable2 and (count(total<Client> distinct MYear)=count(total distinct MYear)) DISTINCT Client)

I want to calculate count of my clients.

Thanks,

[Anonymous]

That's my original expression in Dimension

=aggr(if(Min(aggr(Sum(N_Month), MYear, Client))>Variable2 and (count(total<Client> distinct MYear)=count(total distinct MYear)), Client, null()), Client)

I want to keep conditional and count Clients in expression.

Regards,

[whiteline]

Have you tried the same approach as with avg() in http://community.qlik.com/message/261380#261380 ?

Count({$<Client={"=Min(aggr(Sum(N_Month), MYear, Client))>$(Variable2) and (count(total<Client> distinct MYear)=count(total distinct MYear))"}>} DISTINCT Client)