topic Re: Expression problem in QlikView

Expression problem

Mon, 10 Mar 2014 09:34:28 GMT

Hi, I have this expression:

Sum({<queue={644,647} , goal_id={"<4"}>} answ_call_cnt)+Sum({<queue={644,647} , goal_id={"4"}>} answ_call_cnt)/2/(Sum({$<queue={644,647}>} answ_call_cnt)+Sum({$<queue={644,647}>} aband_call_cnt))

I want to Sum all the values <4 and then add half the values of =4 then devide it with the sum of answ_call and aband_calls.

Can you please help?

SOLVED BY USER // THANKS ANYWAY

Re: Expression problem

tresB — Mon, 10 Mar 2014 09:39:05 GMT

It seems more like proper parenthesis issue. Or, do you doubt something else?

Re: Expression problem

Mon, 10 Mar 2014 09:41:00 GMT

Nope, but i have tried several solutions and can't get it right 😕

Re: Expression problem

tresB — Mon, 10 Mar 2014 09:42:50 GMT

Try to post a sample qvw stating expected output.

Re: Expression problem

Mon, 10 Mar 2014 09:44:19 GMT

Only got private licens and im connected to a ODBC

Re: Expression problem

sunilkumarqv — Mon, 10 Mar 2014 09:46:51 GMT

Try this

Sum({<queue={644,647} ,goal_id={“<$(=4)=$(=4)”}>}answ_call_cnt/13)/(Sum({$<queue={644,647}>} answ_call_cnt)+Sum({$<queue={644,647}>} aband_call_cnt)

Re: Expression problem

er_mohit — Mon, 10 Mar 2014 09:48:16 GMT

Try this

if(wildmatch(queue,'644','647'),

(Sum({<goal_id={'<4'}>} answ_call_cnt)+Sum({<goal_id={'4'}>} answ_call_cnt)/2)

(sum(answ_call_cnt)+sum(aband_call_cnt)))

or this

(Sum({<queue={644,647} , goal_id={'<4'}>} answ_call_cnt)+

Sum({<queue={644,647} , goal_id={"4"}>} answ_call_cnt)/2)

(Sum({$<queue={644,647}>} answ_call_cnt) +

Sum({$<queue={644,647}>} aband_call_cnt))

Re: Expression problem

tresB — Mon, 10 Mar 2014 09:56:54 GMT

Private licence doesn't stop you to share a qvw. Have a look here: Preparing examples for Upload - Reduction and D... | Qlik Community