Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Preciso contar os telefones que houveram rechamadas no prazo de 7 dias.
Isso significa se ele me ligou hoje 05/07/2016 porem ele já tinha me ligado em dentro do período de 7 dias atrás ( 05/07/2016 – 7), eu considero a ligação de hoje como uma rechamada.
Não consegui fazer esse cont.ses dentro do Qlikview, poderia me ajudar?
Exemplo da base
Data Telefone
06/04/2016 111111111
07/04/2016 888888888
08/04/2016 777777777
09/04/2016 99999999
10/04/2016 123456789
15/04/2016 99999999 (Esse telefone é rechamada, pois me ligou no dia 09/07/2016, dentro do prazo de 7 dias atrás)
Preciso do resultado assim:
Data Quantidade de ligações Rechamadas
01/07/2016 33 2
02/07/2016 98 7
Please use below expression
=if(sum({<CallDate=,NumDate = {">=$(vFromDate)<=$(vToday)"} >}CallCount)>1
,sum({<CallDate=,NumDate = {">=$(vFromDate)<=$(vToday)"} >}CallCount))
Ainda não consegui
Tem e-mail?
Hi,
The attached updated QVW shows step by step method of building your expression.
Start with the basic expression:
1st) No of Calls in last 7 days :
sum({<NumDate={">=$(vFromDate)<=$(vToday)"}>}CallCount)
2nd)No of Callbacks in Last 7 days:
if(
sum({<NumDate={">=$(vFromDate)<=$(vToday)"}>}CallCount)>1,
sum({<NumDate={">=$(vFromDate)<=$(vToday)"}>}CallCount)
)
Here we only want to check values greater than or equal to 2
, but the expression total is still incorrect and we only want to sum rows which have more than 2 calls.
3rd)Sum of Callbacks:
sum(aggr(
if(
sum({<NumDate={">=$(vFromDate)<=$(vToday)"}>}CallCount)>1,
sum({<NumDate={">=$(vFromDate)<=$(vToday)"}>}CallCount)
),PhoneNo) )
As we only want to sum rows which satisfy our condition we aggregate by our dimension field, the PhoneNo., and the expression totals are also correct.
Also check the listboxes for additional reference
Cheers
V
Hi,
I've you've found your solution or found an answer as helpful, please ,mark the same and close this post
Thanks
V
Gledson
Conseguiu resolver o problema? Se sim, marque a resposta como correta para ajudar a manter a comunidade organizada.