Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm pulling a count of employees, and need to make a calculated field for a count of "New Hires". I am new to Qlik Sense but have worked in Tableau. The syntax is throwing me for a loop here.
I have it written in Tableau as:
COUNTD (IF DATEDIFF ('day',[Date Hired], DATEADD('day',-1,TODAY () ) ) <=45 THEN [Worker ID] END )
So far in Qlik Sense I have:
Count(IF Date('day',[Worker.HireDate], ' day',-1, Today () <=14 THEN [Worker.Wkr_ID] END)
Any help on the Qlik syntax would be greatly appreciated.
Hi ,
if ( ([Worker.HireDate] - Today ())<45, [Worker ID] ) as newfield
and take count in chart using count(distinct newfield )
Note: take care of date format
Thank you for the response. Is there a way to get it into one statement?