filter data with a variable

Anonymous — Fri, 09 Dec 2016 14:58:44 GMT

Hi all,

Could you please help me?

I want to filter my data with the following data:

if((sum(if([Dep/Ret]='721' and Date(Fecha_mov)<'01/04/2016' ,Movimientos)))=0
  and ((sum(if([Dep/Ret]='721' and Date(Fecha_mov)>='01/04/2016' ,Movimientos)))
  +(sum(If([Dep/Ret]='704' and Date(Fecha_mov)>='01/04/2016',-Movimientos)))
  -Saldo)>0,  'Cliente a contactar','no')

How could I do?

thanks a lot !!!

topic filter data with a variable in QlikView

filter data with a variable