topic Re: Expression error in QlikView

Expression error

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

What's wrong with the below error? Cannot seem to correct the error.

=avg(aggr(AVG(if(ASSIGNED_STATUS = 'NEWLY ASSIGNED MEMBER' AND TEN_PERCENT_FST_CNT <> ('1','2','19','20'),Avg_FIRST_CONTACT_WK_DAYS)), PROGRAM, DIVISION, REGION))

Re: Expression error

m_woolf — Fri, 16 Jun 2017 19:41:58 GMT

I'm pretty sure this statement doesn't work:

TEN_PERCENT_FST_CNT <> ('1','2','19','20')

Re: Expression error

Anonymous — Fri, 16 Jun 2017 19:44:00 GMT

Right. How can I fix this?

Re: Expression error

Anonymous — Fri, 16 Jun 2017 19:58:06 GMT

try

TEN_PERCENT_FST_CNT-= ('1','2','19','20')

Re: Expression error

Anonymous — Fri, 16 Jun 2017 20:14:02 GMT

That's not it

Re: Expression error

Anonymous — Fri, 16 Jun 2017 20:20:22 GMT

avg(aggr(AVG({<ASSIGNED_STATUS = {'NEWLY ASSIGNED MEMBER' },TEN_PERCENT_FST_CNT -={'1','2','19','20'},Avg_FIRST_CONTACT_WK_DAYS)), PROGRAM, DIVISION, REGION)

avg(aggr(AVG({<ASSIGNED_STATUS = {'NEWLY ASSIGNED MEMBER' },TEN_PERCENT_FST_CNT ={'*}-{'1','2','19','20'},Avg_FIRST_CONTACT_WK_DAYS)), PROGRAM, DIVISION, REGION)

Re: Expression error

vishsaggi — Fri, 16 Jun 2017 20:32:45 GMT

May be this?

=avg(aggr(AVG(if(ASSIGNED_STATUS = 'NEWLY ASSIGNED MEMBER' AND NOT Match(TEN_PERCENT_FST_CNT, '1','2','19','20'), Avg_FIRST_CONTACT_WK_DAYS)), PROGRAM, DIVISION, REGION))

Or Extending Wallo's expr: Need to close the set analysis.

avg(

aggr(

AVG( {<

ASSIGNED_STATUS = {'NEWLY ASSIGNED MEMBER' }, TEN_PERCENT_FST_CNT = {'*} - {'1','2','19','20'}

>} Avg_FIRST_CONTACT_WK_DAYS

)

, PROGRAM, DIVISION, REGION

)

Re: Expression error

Anonymous — Fri, 16 Jun 2017 20:35:10 GMT

Thanks for catching that. I missed putting in the closing tags. Sorry OP!