topic Re: Help with expression in QlikView

Help with expression

Anonymous — Mon, 24 Sep 2012 19:11:36 GMT

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,

Re: Help with expression

Anonymous — Mon, 24 Sep 2012 19:27:27 GMT

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,

Re: Help with expression

whiteline — Tue, 25 Sep 2012 09:49:39 GMT

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)