topic Re: Error in expression in QlikView

Error in expression

Tue, 23 Feb 2016 09:29:36 GMT

Hello All,

Could you please help me to get the expression below to work:

=-(1-(sum(total<Friendly_Name,FirstName,LastName>AGGR(

( COUNT( {<FirstAgent={'<>0'}>}ID) / COUNT( TOTAL {<FirstAgent={'<>0'}>}ID) )

, FirstName,LastName,Friendly_Name)* TMTcible/Count({<FirstAgent={'<>0'}>}ID))))

Thanks,

Hasvine

Re: Error in expression

tresB — Tue, 23 Feb 2016 09:37:08 GMT

Try 'not equal to', like:

FirstAgent={'<0>0'}

Or,

FirstAgent -={'0'}

Re: Error in expression

Anonymous — Tue, 23 Feb 2016 09:42:03 GMT

two aggr functions using not working it get the error

Re: Error in expression

andrespa — Tue, 23 Feb 2016 09:45:27 GMT

Hi Hasvine:

=-(1-(sum(total<Friendly_Name,FirstName,LastName>AGGR(

( COUNT( {<FirstAgent-={0}>}ID) / COUNT( TOTAL {<FirstAgent-={0}>}ID) )

, FirstName,LastName,Friendly_Name)* TMTcible/Count({<FirstAgent-={0}>}ID))))

Hope it helps,

Andrés

Re: Error in expression

Anonymous — Tue, 23 Feb 2016 09:46:50 GMT

it taken the only count function

Re: Error in expression

Tue, 23 Feb 2016 09:52:29 GMT

Hello All,

Thank you for your help. the set analysis part is good i believe that the issue lies either with the aggr or with the brackets which are wrongly position as I checked each set individually and it works fine.

Thanks,

Hasvine

Re: Error in expression

andrespa — Tue, 23 Feb 2016 09:58:46 GMT

Hi Hasvine, at first glance I can't tell you more without any sample data. Could you share some to let what's going on?

Cheers,

Andrés

Re: Error in expression

Tue, 23 Feb 2016 10:00:27 GMT

Hi Andres,

I will send you a sample soon. I am preparing it.

Thanks

Hasvine

Re: Error in expression

smirkinaa — Tue, 23 Feb 2016 10:54:51 GMT

Hi. Your mistake is in using function 'Count' like argument of function 'Sum' with in combination with function 'Aggr':

=-(1-(sum(total<Friendly_Name,FirstName,LastName>AGGR(

( COUNT( {<FirstAgent={'<>0'}>}ID) / COUNT( TOTAL {<FirstAgent={'<>0'}>}ID) )

, FirstName,LastName,Friendly_Name)* TMTcible/Count({<FirstAgent={'<>0'}>}ID))))

if we remove expression 'Count({<FirstAgent={'<>0'}>}ID)' formula works.

Re: Error in expression

sunny_talwar — Tue, 23 Feb 2016 11:04:44 GMT

May be this:

=-(1

-(Sum(TOTAL<Friendly_Name,FirstName,LastName>

Aggr(

(

Count({<FirstAgent={'<>0'}>}ID)/Count(TOTAL {<FirstAgent={'<>0'}>}ID)

FirstName,LastName,Friendly_Name))

TMTcible)

Count({<FirstAgent={'<>0'}>}ID))

or this:

=-(1

-(Sum(TOTAL<Friendly_Name,FirstName,LastName>

Aggr(

(

Count({<FirstAgent={'<>0'}>}ID)/Count(TOTAL {<FirstAgent={'<>0'}>}ID)

FirstName,LastName,Friendly_Name))

TMTcible

Count({<FirstAgent={'<>0'}>}ID)))