topic Re: set analysis with multiple conditions Qlik Sense in App Development

set analysis with multiple conditions Qlik Sense

h2bi — Tue, 23 Jan 2024 13:33:43 GMT

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)

Re: set analysis with multiple conditions Qlik Sense

anat — Tue, 23 Jan 2024 14:23:15 GMT

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

Re: set analysis with multiple conditions Qlik Sense

jonashertz — Tue, 23 Jan 2024 14:44:12 GMT

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

Re: set analysis with multiple conditions Qlik Sense

Anil_Babu_Samineni — Tue, 23 Jan 2024 14:50:36 GMT

@h2bi perhaps you need = sign like below?

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