topic Expressions problem with several listboxes. in QlikView

Expressions problem with several listboxes.

Tue, 04 Mar 2014 09:08:53 GMT

Hello!

I have a graph with the expression:

Sum({$<queue={643,646}>} answ_call_cnt)

I also have a list box named: queued_and_answ_call_dur.

I want the Sum for answ_call_cnt to show only for the values over 30 in the queued_and_answ_call_dur.

How do i write an expression like that?

Thank you!

tresB — Tue, 04 Mar 2014 09:13:21 GMT

Try like:

Sum({<queued_and_answ_call_dur={">30"}>} ans_call_cnt)

Tue, 04 Mar 2014 09:44:07 GMT

I still only want to do it for Queue 643 and 646.

And i dont want it to Sum first, i want it to Sum all values OVER 30!

Thanks!

sujeetsingh — Tue, 04 Mar 2014 09:57:09 GMT

Erik just what to do is that derive a flag for the Queue 643 and 646 with call duration >30 and then use this value in your set analysis.

You can use nested if

=sum(if(Queue=643 OR Queue=646,if(queued_and_answ_call_dur>=30,ans_call_cnt)))

=if(Queue=643 OR Queue=646,if(queued_and_answ_call_dur>=30,sum(ans_call_cnt)))

tresB — Tue, 04 Mar 2014 10:00:46 GMT

Simply adding the queue part should work, like.

Sum({<queue={643,646} , queued_and_answ_call_dur={">30"}>} ans_call_cnt)