Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
It seems more like proper parenthesis issue. Or, do you doubt something else?
Nope, but i have tried several solutions and can't get it right 😕
Try to post a sample qvw stating expected output.
Only got private licens and im connected to a ODBC
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)
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))
Private licence doesn't stop you to share a qvw. Have a look here: Preparing examples for Upload - Reduction and D... | Qlik Community