set analysis with multiple conditions Qlik Sense

[h2bi]

I am trying to get distinct number of Operators in the current day (for example there are 20 operators, today were working only 5 operators so must return 5)

So to do this i want to apply 2 conditions, when Day is today and when Number of tasks is not 0 because when there are tasks for an operator it means that operator worked today

My measure:

Count(Distinct {<[Numero de Tareas]-={'0'}, [Día]={'$(vUltimoDia)'}>} Persona)

vUltimoDia is today which i made by max(Día)

[anat]

seems your set analysis is looks fine,may be you can check format of vUltimoDia variable  and Dia  field values.

[jonashertz]

It might not be applicable here but I have had issues with the -= operator in Qlik over the years. If you find nothing else wrong with the set expression try using [Numero de Tareas]={'<>0'} instead..

[Anil_Babu_Samineni · Accepted solution]

@h2bi perhaps you need = sign like below?

Count(Distinct {<[Numero de Tareas]-={'0'}, [Día]={"$(=vUltimoDia)"}>} Persona)