topic Error in expression in QlikView

Error in expression

nikhilgarg — Fri, 19 Jun 2015 10:28:26 GMT

Hello,

I am attachine a qvw. In this i want a column to the right of Client that shows TOTAL of count of Accepted values per client. I tried to do it but error is there.

Thanks

Re: Error in expression

sunny_talwar — Fri, 19 Jun 2015 10:31:01 GMT

You need aggregate function around your Count function in the calculated dimension. May be this:

=Aggr(Count({<State = {'Client-Accept', 'Dealer-Accept', 'Accepted'} , ClientId = {'1', '4', '3'} >}State), Client)

if this is what you want?

Re: Error in expression

alexandros17 — Fri, 19 Jun 2015 10:34:11 GMT

Here it is