Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
lucasx15
Contributor III
Contributor III

Using distinct in expression?

Hello everyone, I needed to create an expression using if and maketime, but I am not able to apply DISTINCT in count. How would you proceed in that case?

=count(
		if((DT_LOS_PROC -DT_PRESC)<=MakeTime(0,30),  %PRIMAY_CLIENTS)
		
		)

 

Labels (1)
2 Replies
rubenmarin

Hi, have you tried?

=count(Distinct
  if((DT_LOS_PROC -DT_PRESC)<=MakeTime(0,30), %PRIMAY_CLIENTS)
)
lucasx15
Contributor III
Contributor III
Author

Thank you very much! I hadn't posted that, thanks!!!