Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

filter data with a variable

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 !!!

0 Replies